attaching report as rtf

[favor08]

Is there a way to change this code so that the document does not go in as a attachment but in the body of the email.

Currenty the person would have to use the forward button in order to keep the document attached to the email. Most cases they would just hit reply, but I need the document to stay attached. Thoughts?

DoCmd.SendObject acSendReport, "RptRequest", "Rich Text Format", , , , "Title", "Please review the attached outstanding balance and advise.", True

[Denburt]

Take a look at this post and see if this helps, I like running my reports into the email body.

http://www.thescripts.com/forum/post3097766-9.html