Reports in email message body

[Guest]

I have a simple trouble ticket tracker in Access that I am trying to send
emails from. The message of the email is from a report. I have no problem
getting the emails out, but they all just show up as attachments, not inline
in the message itself. Previously, about half my team had the message in the
body, the others in an attachment. Then it suddenly stopped, and now no one
has it in the message body. Is there a way to code the SendObject command to
include data from a report in the message body of the email, preferably with
tables and/or formatting intact? I'm not sure if there might be a setting in
Outlook that needs to be changed too, but we couldn't find one.

The code that creates the message is:

DoCmd.SendObject acSendReport, "rptResponseReport", , , , , "CDT Ticket " &
Me.TicketNumber.Value & " " & Me.cboStatus.Value, , True

Thanks.

 

[Scott McDaniel]

I have a simple trouble ticket tracker in Access that I am trying to send
emails from. The message of the email is from a report. I have no problem
getting the emails out, but they all just show up as attachments, not inline
in the message itself. Previously, about half my team had the message in the
body, the others in an attachment. Then it suddenly stopped, and now no one
has it in the message body. Is there a way to code the SendObject command to
include data from a report in the message body of the email, preferably with
tables and/or formatting intact? I'm not sure if there might be a setting in
Outlook that needs to be changed too, but we couldn't find one.

If you're using SendObject, then the only way a report can be sent is as an Attachment, unless you've got code that will
"build" the report in the Message body before your call to SendObject.

In any case, you really can't send a report in the MessageBody with the formatting intact. Closest you'll get is to use
a differnt email engine (like Outlook) and build your report in HTML ... even then, it won't look like your Access
report, but you can usually get it pretty close.

The code that creates the message is:

DoCmd.SendObject acSendReport, "rptResponseReport", , , , , "CDT Ticket " &
Me.TicketNumber.Value & " " & Me.cboStatus.Value, , True

Thanks.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com