Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / October 2004

Tip: Looking for answers? Try searching our database.

Access linking to Outlook Distribution Lists

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michael - 15 Oct 2004 07:57 GMT
I have been asked to create an Outlook "Distribution list" in Outlook from
email addresses held in an Access table.

I have linked from Access to the Outlook Contacts list without any
difficulty but when, in Outlook, I create a Distribution list it, only
appears in the Table linked into from Access as a single row with the
Distribution List name and a special email type - all other colums look to
be blank. I assume that Outlook stores the individual addresses in a
distribution list in another file with some sort of link back to the
Contacts List.

Since my objective is to create and amend distribution lists I need to be
able to add the distribution list name to the Contacts List (that seems to
be no problem) but also to add the individual addresses in the "other file"
but I do not know where it is.

Does anyone have any advice for me please?

All the best,

Michael.
Sue Mosher [MVP-Outlook] - 21 Oct 2004 17:30 GMT
You'd have to write custom code to create and modify the DL with Outlook
objects.

Why are you doing this? A better solution might be to use a Word mail merge
with the Access query as the data source.

Signature

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

>I have been asked to create an Outlook "Distribution list" in Outlook from
> email addresses held in an Access table.
[quoted text clipped - 18 lines]
>
> Michael.
 
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.