Need tips on building large distribution list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

One user wants to have all his contacts in a particular public Contacts list
(we use one of the Outlook user fields to define whose contact this is) added
to a personal distribution list IF the contact has an e-mail address.
Obviously, it can be done manually, but that could take a while going through
a list with 4000 names in it.

Is there a way using Access to connect to a public folder and run this as a
query? I have no experience using Outlook as an Access data source, although
I see that it is possible (is it possible with public folders on Exchange, or
only with .pst contents). I can manage the query & VBA code to create the app
- I just need to know of any connectivity tricks relating to public Contact
folders and how to access the user fields.
 
Not possible. Distribution lists in Exchange folders can contain only about 120 members.

I have to question why the user would want to build such an unmanageable list.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
It is a salesperson who wants to send out mass e-mails periodically to her
entire segment (about 1200 members) of the public folder sales contact list
(about 3500 members).

I like the "not possible" answer, though. It will likely spare me a lot of
grief down the road...
 
I'd use mail merge for that, not a DL.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
I hadn't thought of that - tunnel vision, because I rarely use merges myself.
I will give it a try.

Thanks.
 
Back
Top