Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Emails from MS Access to OutLook

Author  Topic 

Controller1
Starting Member

8 Posts

Posted - 2013-09-03 : 04:45:46
I have read through the below solution on but i am still having problems to generate emails from Access 2010 to Outlook. I need to modify this code to suit my case
http://en.allexperts.com/q/Using-MS-Access-1440/2009/5/MS-Access-07-mass.htm
I have an Emails Table with columns Email, and CustomerCode
The message i want to send is a Report ”Due Invoices”which is sorted by Customer Code; i have done a Force New Page per customer level. Instead of attaching the reports as pdf i prefer more to send as small tables in the body of the email so that when the customer reply i see all the information.
I would like to autoload individual emails per customer from Access 2010 to Outlook 2010.
Any idea how i can do this?
   

- Advertisement -