Email Data

[Parra]

I created a simple data entry form, for a contact and address.

What I would like to do is to email the contact and address that is on the screen to a particular person.

I know I can create a command button to email a report, but how would I create a command button to email the active record with headers?

Thanks
Parra

 

[Parra]

Come on, someone should have an idea of what to do.

From the form view, get the data and add it to the body of an email.

Parra

 

[Parra]

OK, I created a report from a query and added a command button to the form, so that it creates a report from the active screen.

Now I know that instead of previewing the report, I can email it.

Any suggestions on instead of emailing it as an attachment, I can email it in the body of the email???

Also, what about, already selecting, who the email will be sent too??

Please help.

 

[Russell Hauf]

Look up Docmd.SendObject. You can put whatever you want in the To: Subject:, and in the message body...