Send Object

[Par 3]

I am using Access 2000 and want my form to open up and
send two objects within Access and one Excel spreadsheet
via an Outlook email without my intervention. Currently,
I have only figured out how to send one Access object via
an Outlook email and I have to add the other objects, with
Outlook as the focus, and hit the send key (changing the
True to False in code below still prompts me to hit the
send key). Any help would be appreciated. Here is my
code so far:

DoCmd.SendObject acReport, "rptExample",
acFormatSNP, _
"Addressee1, Addressee2, Addressee2", , , _
EmailSubject, "Example Email Title.", True

 

[Andy Williams]

There is an option in Outlook Express on the Security Tab under Options
which allows you to switch off the warning you get about another program
trying to send an E-Mail I suspect a similar option exists in Outlook
although I can't be sure as I don't have it installed. Once you deselect
this option and use False in your Docmd statement it sends automatically
without intervention.

I'm not sure if you can disable this option programatically or about whether
it's a good idea to permanently disable this warning, perhaps someone else
knows more than me about it and can enlighten us.