Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2005

Tip: Looking for answers? Try searching our database.

Sending mail merged emails to recepients in a database?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
axion - 08 Mar 2005 14:55 GMT
I want to send out emails to customers I hold on a database through Outlook
but I can't work out how to automaticallly generate the receipients' email
address line in order to send them.
Peter Jamieson - 08 Mar 2005 16:14 GMT
If you are doing a bulk e-mail and can use mailmerge then, when you actually
perform the erge, you get the option to set a subject (the same for all the
e-mails) and a recipient address, which word can get from any field in the
database table/view/query you are using as the data source for the merge. So
as long as your data source has the e-mail address, you can do it that way.
If the data source does not have the e-mail address, then you obviously need
some reliable way of looking up the recipient's e-mail address from the data
in the data source (and there are potentially various ways to do that,
depending on what data you have - if you need more ideas on that, let us
know what types of info. you have in your data source).

Alternatively, you might be able to adapt the article by Doug Robbins at

http://word.mvps.org/faqs/mailmerge/MergeWithAttachments.htm

(although it is about merging attachments, it also shows how to send e-mails
programatically from Word)

Peter Jamieson

>I want to send out emails to customers I hold on a database through Outlook
> but I can't work out how to automaticallly generate the receipients' email
> address line in order to send them.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.