Contents of record to outlook message

[Gary Hull]

Hello

I would like to open a form to a specific record
When I press a button on the form I need the contents of the specific
record attached to an email.

thanks

 

[Daniel Pineault]

Different approached are possible depending on your needs.

1. Create a report which is limited to the current record and use the
SendObject method to email it.

For an example to learn from take a look at
http://www.rogersaccesslibrary.com/download3.asp?SampleName=EmailingSpecificReports.mdb



2. Use Outlook automation and pass the values of each control to the body of
the e-mail message.

For basic outlook automation code take a look at
http://msdn2.microsoft.com/en-us/li...odc_ac_olauto_sendanoutlookmessageusingaccess

Also this could be of interest
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Report_SendInMailBody.mdb'
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.