Send records to outlook

[tmongy]

I have a form linked to a table. The table has many fields...I would like to have a button on the form that allows the user to send records to outlook, but with the option to include or exclude certain fields before sending it, is this possible? Also, is it possible to have the records appear in outlook as text in the message body, not as an attachment?
Thanks

 

[reclusivemonkey]

Yes it is possible, you need to filter the records you require, write some VBA to concatenate the fields you want into a text string, then use DoCmd.SendObject