Hi Curtis,
If I was setting out to export email addresses from an Access database
to an Outlook distribution list, I'd start by hunting through the
Outlook object model to see whether the distribution list object
(whatever it's called) stores a collection of email addresses or a
collection of contacts or address-book entries of some kind.
If the former, you just need to write code to create a distribution
list, then open a recordset on the Access query and iterate through the
records adding each email address to the list.
If the latter - which I feel is more likely - you might need to export
all your Access records to an Outlook Contacts folder and then create
the list to include all the contacts in that folder. See
http://www.outlookcode.com and
http://www.slipstick.com for information
on programming Outlook.
If your data is in Access, you may prefer to leave Outlook out of the
equation and generate the emails in Access. See Tony Toews's email page
at
http://www.granite.ab.ca/access/email.htm
