Access linking to Outlook Distribution Lists

[Michael]

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

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.