Need tips on building large distribution list

[Brian]

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.

 

[Sue Mosher [MVP-Outlook]]

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

 

[Brian]

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...

 

[Sue Mosher [MVP-Outlook]]

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

 

[Brian]

I hadn't thought of that - tunnel vision, because I rarely use merges myself.
I will give it a try.

Thanks.