View Single Post
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

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/...ttachments.htm

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

Peter Jamieson


"axion" wrote in message
...
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.