export email addresses

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am trying to export 600 plus email addresses from Access into an Outlook
distribution list so I can send an announcement to the group.

Any help would be appreciated,

Rob
 
I'm trying to do the same thing. If this not possible I wish MvP's would say
so. I lost a DL of 1000 Email addresses. After spending frustrating hours
trying to get them back I decided to put them into Access. I spent hours of
frustration doing this but it's accomplished. Ithik ACCES is a place to store
these Emails. However, it is not good for mass mailing.
And now I find I still can't export into a DL?
This really stinks.
Do I admit defeat and simply type in all one thousand emails into a new DL?
Please give me advice.
Regards,
Curtis
 
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
 
Back
Top