Email from access

[ryan.sarmast]

Can someone help me with some ideas about how I would go about sending
an email from access. This file needs to have a text document as an
attachment. I have tried Mapi and CDONTS with no luck.
Thanks
Ryan Sarmast

 

[Guest]

Ryan,

I've used Arvin Meyer's example to send e-mail from Access. Try
http://www.datastrat.com/DataStrat2.html "EmailSenate" or "EmailSenate2K"
are two example databases that demonstrate the procedures. You'll have to
make a few changes to adapt to your situation.

 

[Arvin Meyer [MVP]]

Also, if using Outlook he can try using the code at:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Philip Leduc]

If you do not want to reinvent the wheel,
FMS has a tool "total Access emailer" for 499$. (includes royalty free
runtime version)
I have not used it myself, they did send out a trial version not long ago
see fmsinc.com