DoCmd.SendObject - body text not appearing but is specified

[Guest]

Hi

Hope someone can help.

I'm using the DoCmd.SendObject command to send an email with a spreadsheet
attachment of a query output. I specify a subject line and body text,
however when I run the code and the email opens in Outlook for editing, the
body text is blank (subject line and attacment appear fine).

Now, when I send the email as it is (blank), the recipient will receive the
email with the body text I specify in my code, even though I cannot see it
when sending.

If I type something in the body of the email that is generated, as a user
would do when they see the email is blank, and then send it, the text I type
appears on the recipients email with none of my code-specified body text.

This happens in both Access 97 and Access 2003. I'm using Outlook 2003.

Line of code I'm using as a test is:

DoCmd.SendObject acSendQuery, "tmp_qry_applicant_pd", acFormatXLS, , , ,
"Test Email", "Test Email"

Thanks in advance

Russell

 

[TC]

There are several other posts with this question, but they do not seem
to have got many answers.

As a complete stab in the dark on my part, try providing all of the
parameters - even if only empty strings ( ... , "", ... ) and see if
that fixes it.

HTH,
TC [MVP Access]