Sending an Email from Access 2010

[TShaq]

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

 

[OBP]

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.

 

[TShaq]

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

 

[OBP]

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.