Sending an Email from Access 2010

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

TShaq

Thread Starter
Joined
Mar 25, 2015
Messages
2
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

Joined
Mar 8, 2005
Messages
19,895
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.
 

Attachments

TShaq

Thread Starter
Joined
Mar 25, 2015
Messages
2
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

Joined
Mar 8, 2005
Messages
19,895
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top