SendObject does not send when EditMessage is False?

[Jason Gyetko]

I can't get my report to be emailed using SendObject when EditMessage is
False. It works fine if I set it to True, all I have to do is click send
when it comes up. I need it to be automated though. Does anyone know what
I may be doing wrong or if it is a bug? I'm using Access 2000.

Here is the statement that I'm using:
DoCmd.SendObject acReport, "rptPacklist", acFormatSNP, (e-mail address removed), , , , ,
False

I also tried this, which I generated from a macro (the macro wouldn't work
either):
DoCmd.SendObject acReport, "rptPacklist", "SnapshotFormat(*.snp)",
"(e-mail address removed)", "", "", "", "", False, ""

 

[Rick Brandt]

I can't get my report to be emailed using SendObject when EditMessage is
False. It works fine if I set it to True, all I have to do is click send
when it comes up. I need it to be automated though. Does anyone know what
I may be doing wrong or if it is a bug? I'm using Access 2000.

Here is the statement that I'm using:
DoCmd.SendObject acReport, "rptPacklist", acFormatSNP, (e-mail address removed), , , , ,
False

I also tried this, which I generated from a macro (the macro wouldn't work
either):
DoCmd.SendObject acReport, "rptPacklist", "SnapshotFormat(*.snp)",
"(e-mail address removed)", "", "", "", "", False, ""

SendObject was (for intents and purposes) unusable in Access 2000, although I have
seen some reports that the problems were corrected in ServicePack 3 (which included
the dreaded Outlook Security patch).

You can automate Outlook or CDO as an alternative.