G
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
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