Email with Access form

[xeLcapytan983x]

Hello,

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?

Thanks

[zmbd]

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.