I need to update my contacts, and would like to send out a message to
each contact and let them know what dl's I have them in, among other
things.

My searches thru google groups seem to bring up stuff on creating dl's
from contacts, not checking contacts that are included in dl's.

I have done considerable VBA work in Access, and some in Excel, but
have never even touched VBA within Outlook, and am not sure how to
approach this. I would like to be able to send out these messages
possibly 1-2 times a year, using some sort of template for the message.

Any help or pointers would be greatly appreciated.

You would have to iterate the Contacts folder to get each DL, then check all its members against the contacts you have, then organize that information in some way that would let you build a list of DLs for each contact. You could put the list in a property in each contact and save it for posterity. Or maybe you could build a dynamic list with a Dictionary object.

Outlook VBA basics start at http://www.outlookcode.com/d/vbabasics.htm and http://www.outlookcode.com/d/vb.htm

Why, though, would any contact be interested in what DLs you have them in, since the DL is merely a construct for your own convenience?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

wrote in message oups.com...
I need to update my contacts, and would like to send out a message to
each contact and let them know what dl's I have them in, among other
things.

My searches thru google groups seem to bring up stuff on creating dl's
from contacts, not checking contacts that are included in dl's.

I have done considerable VBA work in Access, and some in Excel, but
have never even touched VBA within Outlook, and am not sure how to
approach this. I would like to be able to send out these messages
possibly 1-2 times a year, using some sort of template for the message.

Any help or pointers would be greatly appreciated.

Sue,

Thanks for the reply!

I deal with many administrators that need to be re-assured that they
will be included when I send out info for various products. I am
constantly being asked if they are included in the dl for such and such
a product

My dl's have the name/"File As" properties in the form of "_DL,
ProdName" with the ProdName being the appropriate Product. By sending
each contact a list of which dl they are in and what is available, I
could be assured that I am not missing somebody when I send out my
updates, as well as giving the contacts a way of opting out.

I'll check out the links you included. Is this the best group to ask
this type of questions, or would you recommend another? As I said,
Outlook programming is new, but I do look forward to plumbing is depths
a bit.

Thanks again for your help!


Sue Mosher [MVP-Outlook] wrote:
You would have to iterate the Contacts folder to get each DL, then check all its members against the contacts you have, then organize that information in some way that would let you build a list of DLs for each contact. You could put the list in a property in each contact and save it for posterity. Or maybe you could build a dynamic list with a Dictionary object.

Outlook VBA basics start at http://www.outlookcode.com/d/vbabasics.htm and http://www.outlookcode.com/d/vb.htm

Why, though, would any contact be interested in what DLs you have them in, since the DL is merely a construct for your own convenience?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

wrote in message oups.com...
I need to update my contacts, and would like to send out a message to
each contact and let them know what dl's I have them in, among other
things.

My searches thru Google groups seem to bring up stuff on creating dl's
from contacts, not checking contacts that are included in dl's.

I have done considerable VBA work in Access, and some in Excel, but
have never even touched VBA within Outlook, and am not sure how to
approach this. I would like to be able to send out these messages
possibly 1-2 times a year, using some sort of template for the message.

Any help or pointers would be greatly appreciated.