send email in access

[JIM.H.]

Hello,
Is there any other way other than using SendObject to send
an e-mail in access? Any examples?
Thanks,
Jim.

 

[Cheryl Fischer]

Automation of Outlook is another way to go. It requires more VBA code but
offers much more in the way of options. There is sample code at the
following link which can get you started:

http://tinyurl.com/2knwj

 

[Cheryl Fischer]

Also, see here:

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

 

[Sandra Daigle]

Hi Jim,

Start by looking here:

Tony Toew's Email FAQ
http://www.granite.ab.ca/access/email.htm

Here are some other articles that might also help you:

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881

 

[Tony Toews]

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881

Hmm, that's a new one I didn't have. Thanks.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm