A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can I create Outlook Distribution List from Access database?



 
 
Thread Tools Display Modes
  #1  
Old June 7th, 2010, 11:16 AM posted to microsoft.public.outlook.general
Jan Main
external usenet poster
 
Posts: 1
Default 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  
Old June 7th, 2010, 12:50 PM posted to microsoft.public.outlook.general
Shawn76 via OfficeKB.com
external usenet poster
 
Posts: 56
Default 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  
Old June 7th, 2010, 12:57 PM posted to microsoft.public.outlook.general
Sue Mosher [MVP][_3_]
external usenet poster
 
Posts: 232
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:52 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.