Building a distribution list from Access

[Margaret Bartley]

Office 2003

We are using Access to manage our customer database. When I send out a
newsletter, I manually import the Access table, ValidEmails, into a new
Outlook 2003 Distribution List, and then manually divide that list into
thirds. (Our ISP chokes when I get more than about 400 emails in a single
bcc field)

So, I want to automate this. All the code I've found on the web involves
creating a contact for every person in our ValidEmail table, resolveing the
naem, and then appending recipients to the newly-created distribution list.

But, I don't want to add all these to our Outlook Contacts. When I'm
importing them manually, names that are in our Access database, but not in
the Contacts folder are put into the Distribution list. Isn't there a way
to do this in code?

[Ken Slovak - [MVP - Outlook]]

You can write code that would take each email address and add it as a
Recipient object to an email, as many as you want for each email. Then you
use the Resolve() method on each Recipient object as you get a handle to it
back from the Recipients.Add() method. That will create one-off recipients
that are not in your contacts folders.

However, you might want to investigate if there are already programs out
there that do mailings directly from Access as an alternative to writing
your own code.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm

Post by Margaret Bartley
Office 2003
We are using Access to manage our customer database. When I send out a
newsletter, I manually import the Access table, ValidEmails, into a new
Outlook 2003 Distribution List, and then manually divide that list into
thirds. (Our ISP chokes when I get more than about 400 emails in a single
bcc field)
So, I want to automate this. All the code I've found on the web involves
creating a contact for every person in our ValidEmail table, resolveing
the naem, and then appending recipients to the newly-created distribution
list.
But, I don't want to add all these to our Outlook Contacts. When I'm
importing them manually, names that are in our Access database, but not in
the Contacts folder are put into the Distribution list. Isn't there a way
to do this in code?