I'd like to set up a button on a form that will take information from that record and send an email to the address on the form. I want the body of the email to be a form letter with fields from the record (Name, comments, etc). I have done this in the past by creating a report, printing it to pdf, and then emailing that, but now I'd like to send the info as the body of the email instead of as an attachment. I'd like the email to be formatted as well.
I've done some reading about mail merges and I can see how to create a merge in Word that can access the database for the fields, but I'm not sure how to do a mail merge that results in emails instead of paper letters. Also, ideally the solution would be a one-click operation handled (from the user perspective) entirely within Access.
Any one have a good place to start? I have limited experience in VBA and slightly more in Access in general.