 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / January 2004Sending to many recipients from an Access database
Hi, I have an access database from which I want to sent email. I've manage to get it working, except that I don't find how to send the email to more than 1 person at a time. In my database, I have many field containing email address. I've tried to "merge" them in many ways, eg: abc@hotmail.com and def@hotmail.com --> I've tried abc@hotmail.com;def@hotmail.com, or replacing the ; with a space, or with a ",". But when I do it, nothing is sent. thanks, Benoit If this is really an Access + e-mail question, you will probably get a better answer in an Access group. If you are going via Word mailmerge, in my experience there is no way to specify more than one address at a time in the "To" field (in other words, none of the obvious choices such as delimit with spaces, commas, semi-colons, or use an Outlook distribution list actually works). So in that case you have to generate one e-mail per recipient. If you are going via "Send document via e-mail", I don't know whether multiple addresses can be mde to work but I can't really see why they would not - you could start with the Doug Robbins/?Graham Mayor article somewhere on http://word.mvps.org . -- Peter Jamieson - Word MVP Word MVP web site http://word.mvps.org/ > Hi, > I have an access database from which I want to sent email. I've manage to get it working, except that I don't find how to send the email to more than 1 person at a time. > In my database, I have many field containing email address. I've tried to "merge" them in many ways, eg: abc@hotmail.com and def@hotmail.com --> I've tried abc@hotmail.com;def@hotmail.com, or replacing the ; with a space, or with a ",". But when I do it, nothing is sent. > thanks, > Benoit thanks, I'm using Access to analyse some internal design data, then I use word to send msg to designers to explain to them what they need to do. Then next week I refresh my data, but I can see if the designer has made the required changes. So to answer you question, no, I cannot use "send to by email" (I'm not sending the database). I need multiple To: because sometimes I need to inform the manager also. cheers, Benoit >-----Original Message----- >If this is really an Access + e-mail question, you will probably get a [quoted text clipped - 24 lines] > >. do you know of any other tool I could use to send email from Access ? >-----Original Message----- >If this is really an Access + e-mail question, you will probably get a [quoted text clipped - 24 lines] > >. > do you know of any other tool I could use to send email > from Access ? The approach I mentioned may be enough: > If > >you are going via "Send document via e-mail", I don't [quoted text clipped - 4 lines] > somewhere on > >http://word.mvps.org . But if you are going to use VBA, you should be able to use the Outlook object model or CDO directly from Access to do what you want, especially if the message content does not have to be complicated. -- Peter Jamieson - Word MVP Word MVP web site http://word.mvps.org/ > do you know of any other tool I could use to send email > from Access ? [quoted text clipped - 44 lines] > > > >. |
Reply to this Message |
 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.