How to create a distribution list from MS Access

[schultzm]

Can anyone assist me in creating a distribution list for use with Office 2003 from an MS Access 2003 database?

Many thanks in advance.

[Paul Komski]

I dont know a way of directly accessing the address book from access (though there may be third party odbc drivers/software that can enable this).

You can however easily set up an approriate database table (or query) in a new Access Database. Start the New Office Document shortcut and then choose the Databases tab and choose the Contact Management wizard.

When this has been set up you can import/export the data as a CSV (comma separated values) text file. Open the Contacts Table (or any query you may have made) and choose save as/export and then choose to export a .csv text file.

You can then similarly import/export .csv files using outlook's address book.

You thus use the .csv file as the intermediary.

[schultzm]

I am actually looking to obtain the addresses from Access via Outlook so I am looking for an interface to do this.

Importing the addresses to Outlook via a file is of course possible.

[Paul Komski]

There is direct linkage in Access2003 without configuring ODBC that I wasnt aware of.

See:- http://office.microsoft.com/en-us/assistance/HA011165811033.aspx