By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,191 Members | 1,256 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,191 IT Pros & Developers. It's quick & easy.

Email with Access form

P: 4

I am trying to have access generate an email in outlook and have the "To:" field auto-fill with the information in the email field, along with the remaining fields in the table populating in the body.

I am not well versed in vba, is there a front end method that I could walk a non-user through?


Attached Images
File Type: jpg form view.jpg (14.5 KB, 158 views)
Dec 4 '13 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,397
For simple emails the docmd.sendobject() method will usually do the trick, you can get to this in the ribbon, external data, export, keep in mind that only the PDF and the XPS formats will keep your form/report format intact. Using VBA then you need to look at DoCmd.SendObject Method (Access/Office 2010) which is basically the same thing as using the ribbon just that you will be able to use a recordset to cycle thru a email list. For more complicated emails then you need to look at Application Automation or the CDO method

IN anycase using the sendobject method often has limitations on the length of the body text; thus, if you are using a memo field for the body text message expect it to be truncated to 255 charactors.
Dec 4 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.