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.

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.

--
HTH
Dan Artuso, Access MVP


"Mike Stockport UK" <Mike Stockport (E-Mail Removed)> wrote in message
news6998ED4-31E0-41BE-8613-(E-Mail Removed)...
> 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.

Thanks for that, my mistake, works fine now

"Dan Artuso" wrote:

> 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.
>
> --
> HTH
> Dan Artuso, Access MVP
>
>
> "Mike Stockport UK" <Mike Stockport (E-Mail Removed)> wrote in message
> news6998ED4-31E0-41BE-8613-(E-Mail Removed)...
> > 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.
>
>
>