DoCmd.SendObject Report as Body of Email not attachment

S

sayrevilleNJ

Hi,

I am using following code to send "Access Report" in an email. It use to
send Report in a body of email, but since we switched to Outlook mail client,
now it goes as an attachment. Can you please suggest how can I force the
report to go in Body instead of attachment in Outlook mail client.

stDocName = "rpt_myReport"

stLinkCriteria = "[ID]=" & Me![ID]

DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

DoCmd.SendObject acSendReport , , , [mail], , , "New Subject"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Office 365 Outlook adding unwanted HTML to Email Body 0
Sending Email in txt format 10
SendObject format 6
Send report as text in body of email 3
Access 2007 to Outlook 2007 Attachment 2
EMail Report --NOT AS ATTACHMENT 21
Email a report NOT as an attachment 5
Report format not showing up in RTF 1

Top