Email from access

[Jedireg]

Can anyone point me in the right direction for sending emails from an
access database. I would like the user to be able to click on a button
and have an email sent to an address stored in the table with an
attachment created by the access form. (ex. attach an excel sheet to
the email). Doing a google search I've only been able to find examples
of linking access with outlook, which i do not use.

Thanks

Glenn

 

[Daniel Pineault]

There are various solutions depending on your needs. Take a look at the
..SendObject Method or if you wish to automate Outlook then take a look at
http://www.devhut.net/index.php?lang=en&pid=0000000013#OutlookAuto
--
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.

 

[Jedireg]

There are various solutions depending on your needs. Take a look at the
.SendObject Method or if you wish to automate Outlook then take a look at
http://www.devhut.net/index.php?lang=en&pid=0000000013#OutlookAuto

I'll check out the .SendObject and see where that gets me as outlook it
not an option, we are forced to use lotus notes... :-(

 

[Daniel Pineault]

Lotus is fine, if you wish to automate it, take a look at:
http://www.fabalou.com/VBandVBA/lotusnotesmail.asp
--
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.

 

[Tony Toews [MVP]]

I'll check out the .SendObject and see where that gets me as outlook it
not an option,

SendObject's twenty limitations
http://www.granite.ab.ca/access/email/sendobject.htm

we are forced to use lotus notes... :-(

Microsoft Access Email FAQ - Lotus Notes
http://www.granite.ab.ca/access/email/lotusnotes.htm

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/