Send Email direct from MS Access 07

Stuzza71
Stuzza71 used Ask the Experts™
on
Hi Experts,
I am looking for a way to either send an Email directly from MS Access 2007, or send via some sort of command line Email tool.
Essentially, I would like to avoid having to install and manage an Email client for this task as we use lotus Notes, it is an added level of difficulty.
Does anyone know of an easy way to do this?
Also, any VBA code samples required to invoke this would be useful as well.
I would like it to be capable of running on Windows 7 and server 2003 and 2008.
I would also like to be able to send attachments as well, but not critical.

Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
If you are not using your email client you will need access to an smtp server but regarding the method of sending
check this post on here.

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21336007.html

hope this helps

Author

Commented:
Thanks Ross,
Exactly what I was looking for.

Stuzza....

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial