SendObject - Email Missing Messagetext

G

Greenozzy

I'm having an issue trying to e-mail a report from access. The following is
the code that I am using

stDocName = "rptCMReport"
stTo = "[email protected]"
stSubject = "#" & RequestId.Value & " - " & Subject.Value
stBody = "The following is an approval request for task '#" &
RequestId.Value & " - " & Subject.Value & "'. This request has a scheduled
implementation date of " & ImplementationDate.Value & ". The attached
document contains detailed information on this task."
DoCmd.SendObject acSendReport, stDocName, acFormatRTF, stTo, , , stSubject,
stBody, True

When the code runs, it creates the e-mail with the attachment, but with no
body text. The stBody text is completely missing.

As a test, I excluded the attachment (as follows)

DoCmd.SendObject , , , stTo, , , stSubject, stBody, True

In this instance, the e-mail was created with the body text.

I checked the help file and couldn't find anything on this. I have also
searched the net and not found anything on this either. Are the attachment
and body text mutually exclusive? Could this have something to do with
running this to Lotus notes instead of Outlook?

Any help would be appreciated.
 
Top