sending email from Access

[Benoit D.]

Hi,
I want to be able to send email from Access. I've done it
using Word, but the problem is that I cannot specify more
than 1 recipient on the To: list.
Is there other way to send email from access?
I don't want to send the database. I'm doing data
analysis, and I need to inform different people about some
errors that they have made. I sometime need to send it to
many people because I'm sending it to their manager as
well.
The problem is that with Word, there is no way to specify
multiple names on the to list.
I would like to know if there are other tools I could
connect to from access.

thanks.
Benoit

 

[Cheryl Fischer]

You might want to investigate using Automation with Outlook. There is
sample code at the following link that can get you started:

http://tinyurl.com/2knwj

Also, have a look at Tony Toews' email page:

http://www.granite.ab.ca/access/email.htm

 

[Mike]

You can create a macro to do it. SendObject is the
action. At the bottom you can specify who you want to
send it to. Seperate e-mail addresses by ; (semi-
colons). You can the create a command button on a form
and link that to the macro. I use Microsoft Outlook and
it works great for me. Good luck!

Mike