I have a form that allows you to select a record from a query. It populates a number of text boxes with data from the table. I would like to use a macro attached to a button that will construct the email subject and body and send using HTML rather then plain text in outlook. The send object method does not appear that it will work for this. Occasionally, an attachment needs to be send also, which is stored in the tbl as well.

Any help would be appreciated.