I can't send an Access report via email using DoCmd.SendObject ac.

[Guest]

When I send a report via email using a command button the following code
runs. This code works on some XP machines and not others.

DoCmd.SendObject acReport, stDocName, "html"

When it doesn't work the error message is

"***** can't send this format in a mail message"

where ***** is the access program name.

Note if you take the "html" off and allow a prompt box to come up and then
select 'HTML' it works.
Also if you change it "html" to "rtf" it works.

Has anyone seen this before.

 

[Dan Artuso]

Hi,
I'm not sure why it works at all because the format argument should be a constant.
Here's the snippet from Help:

outputformat One of the following intrinsic constants:
acFormatHTML
acFormatRTF
acFormatTXT
acFormatXLS
If you leave this argument blank, Microsoft Access prompts you for the output format.

Note that these equate to numbers, not strings.

 

[Guest]

Thanks for that, my mistake, works fine now

Hi,
I'm not sure why it works at all because the format argument should be a constant.
Here's the snippet from Help:

outputformat One of the following intrinsic constants:
acFormatHTML
acFormatRTF
acFormatTXT
acFormatXLS
If you leave this argument blank, Microsoft Access prompts you for the output format.

Note that these equate to numbers, not strings.