Sending to many recipients from an Access database

[benoit desrosiers]

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: (e-mail address removed) and (e-mail address removed) --> I've tried (e-mail address removed);[email protected], or replacing the ; with a space, or with a ",". But when I do it, nothing is sent.

thanks,
Benoit

 

[Peter Jamieson]

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: (e-mail address removed) and (e-mail address removed) -->
I've tried (e-mail address removed);[email protected], or replacing the ; with a
space, or with a ",". But when I do it, nothing is sent.

 

[Guest]

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
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/

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. address. I've tried to
"merge" them in many ways, eg: (e-mail address removed) and

(e-mail address removed) -->

 

[Guest]

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
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/

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. address. I've tried to
"merge" them in many ways, eg: (e-mail address removed) and

(e-mail address removed) -->

 

[Peter Jamieson]

do you know of any other tool I could use to send email

from Access ?

The approach I mentioned may be enough:

If

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.