Email from Access

Frank Freese
Frank Freese used Ask the Experts™
on
Experts,
I'm trying to get my arms around emailing from Access. Our company uses Outlook to interface with our Exhnage Server.

Currently, purchase orders are being created using QuickBooks and emailed from QuickBooks. I suspect this same task is available in Access.

In order to email what is the process(es) I need to be thinking about as I build this application?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011
Commented:
Access have very limited emailing capabilities. Outlook is the application in the Office suite for Email.

Depending on what you want to email you could use the Docmd.SendObject method. I generally use Outlook Automation from Access.  



I agree with HiTechCoach, you can either use Outlook Automation or other e-mail clients.
The SendObject() method has limited possibilities, while with the Outlook Object you have more option available.

Below an example on how to apply Outlook Automation using Acces 2010 using the redemption COM model (late binding, thanks to Jack D Leach):
http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/c5cb8567-0796-4b57-bee5-13dae6e313bd

See this demo, if you want to via SMTP with CDO;
http://www.utteraccess.com/forum/Sending-Email-Smtp-Cdo-t1957295.html

HTH,
Daniel
MIS Liason
Most Valuable Expert 2012
Commented:
Your biggest hurdle will be getting the Quickbooks data into Access.
Then depending on what *Exactly* you will be emailing, you will have to design the email "Output".

Using Access you can use SendObject to send an email from Access
The basic syntax is:
Docmd.SendObject ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile
You can research this in the help files.

If you need more flexibility in the email (HTML text in the email body, Tracking, Importance, ...etc) the you will have to use Outlook Automation from Access:
http://support.microsoft.com/kb/161088

This may be all you need to get you started.

As the other Experts have pointed out, there are systems that will do all of this for you (and bypass Outlook Security, and provide more options)
Here is another popular tool designed especially for Access:
http://www.fmsinc.com/MicrosoftAccess/Emails.asp

JeffCoachman
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
thanks folks -
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Are you using Qodbc to interface QB with Access...?
http://www.qodbc.com/
Jeff: Thanks for mentioning Total Access Emailer.

Please let me know if you have any questions about Total Access Emailer and how it can run interactively as an add-in (no programming required) or via VBA. It will automatically let you send personalized emails using data from your data source  (table or query) and attach reports that can be filtered for each recipient.

Free trial version here: http://www.fmsinc.com/MicrosoftAccess/Email/free-trial.html

Author

Commented:
Thank Luke - when I begin to build that function I'll look at tis product.

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