Sending an Email from Access 2010

Hello All,

I'm trying to send an email out of access. Once the user completes the form he/she clicks a button and the email is sent. Now, I have figured out how to send the form as an attachment; however, I would like the form data included in the message body. I assume this requires some SQL or VBA coding that I'm not familiar with, so any help would be sincerely appreciated.

Thanks!

TShaq

 

TSaq, welcome to the Forum.
Try this emailing test database that I put together a few years back, it takes the data from the Form and puts it in the email body for different email programs.
There are 4 buttons, ensure that you unzip it first.

 

Hey I do really like that and can probably use it for something else. But here's the idea, I already have the forms setup where the user inputs data related to a table. I would like the email to send the data within the form I created. Any thoughts? I think this is awesome, but doesn't exactly accomplish what I'm trying to do.

Thanks!

TShaq

 

You can use the code that I provided by modifying it to the Field Names on your Form and adding any extra lines needed for more fields, if you have a look at this code

Body = Me.Body & Chr$(13) & [Text2] & Chr$(13) & [Text3] & Chr$(13) & [Text4]

You can add text to it where needed.
The CHR$(13) is a line feed to move to the next line.