Email with Access 2003 and not Outlook

[Tony]

I want to send emails using Access 2003 VBA and NOT go through Outlook to do
it. Is there a way to use SMTP or some other code that will send an email
directly from Access without having Outlook installed on the users computer?

 

[Daniel Pineault]

Take a look at

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

Tony covers all the available e-mail techniques. Check them out and use
which ever one best suits your needs.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Stuart McCall]

I want to send emails using Access 2003 VBA and NOT go through Outlook to
do
it. Is there a way to use SMTP or some other code that will send an email
directly from Access without having Outlook installed on the users
computer?

You could try my CDO class module. You'll find it here:

http://www.smccall.demon.co.uk/Downloads.htm#cdo