Prev: Unable to create my work email account on exchange server
Next: exchange related?
From: Jan Main Jan on 7 Jun 2010 06:16
Is it possible to create a Distribution List from email addresses already
stored in an Access database.
I can send an email to each individual email address listed in the database,
but would like to send the same email to several of the email addresses in
one go.
From: Shawn76 via OfficeKB.com on 7 Jun 2010 07:50
yes you can

http://library.cortland.edu/tps/materials/distributionlistaccess.pdf


Jan Main wrote:
>Is it possible to create a Distribution List from email addresses already
>stored in an Access database.
>I can send an email to each individual email address listed in the database,
>but would like to send the same email to several of the email addresses in
>one go.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-outlook/201006/1

From: Sue Mosher [MVP] on 7 Jun 2010 07:57
You don't need (and shouldn't bother with) a distribution list for that.
This can be done with Outlook VBA code that creates a message (CreateItem
method) and sets the To property of the message to a semi-colon delimited
string of the desired addresses.

Note, though, that this means each recipient will see the others' addresses,
which might not be desirable for privacy reasons. Your existing technique,
which I presume is mail merge, might be better for that reason (and because
it requires no code.

Please post follow-up any questions or comments to the forum at
http://social.answers.microsoft.com/Forums/en-US/outlooksend/threads as this
newsgroup will be discontinued any day now.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54



"Jan Main" wrote:

> Is it possible to create a Distribution List from email addresses already
> stored in an Access database.
> I can send an email to each individual email address listed in the database,
> but would like to send the same email to several of the email addresses in
> one go.
 | 
Pages: 1
Prev: Unable to create my work email account on exchange server
Next: exchange related?