If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I create Outlook Distribution List from Access database?
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. |
#2
|
|||
|
|||
Can I create Outlook Distribution List from Access database?
yes you can
http://library.cortland.edu/tps/mate...listaccess.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.a...tlook/201006/1 |
#3
|
|||
|
|||
Can I create Outlook Distribution List from Access database?
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/...oksend/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. |
Thread Tools | |
Display Modes | |
|
|