 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / October 2005Need tips on building large distribution list
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.  SignatureSue 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 > 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 [quoted text clipped - 8 lines] > - I just need to know of any connectivity tricks relating to public Contact > folders and how to access the user fields. 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... > Not possible. Distribution lists in Exchange folders can contain only about 120 members. > [quoted text clipped - 12 lines] > > - I just need to know of any connectivity tricks relating to public Contact > > folders and how to access the user fields. I'd use mail merge for that, not a DL. SignatureSue 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 > 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 [quoted text clipped - 6 lines] >> >> I have to question why the user would want to build such an unmanageable list. >> > 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 [quoted text clipped - 8 lines] >> > - I just need to know of any connectivity tricks relating to public Contact >> > folders and how to access the user fields. I hadn't thought of that - tunnel vision, because I rarely use merges myself. I will give it a try. Thanks. > I'd use mail merge for that, not a DL. > [quoted text clipped - 21 lines] > >> > - I just need to know of any connectivity tricks relating to public Contact > >> > folders and how to access the user fields.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.