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.