DoCmd.SendObject

[RangerFan]

I am attempting to send myself an email with an attached Access report.

I am using the folowing code:

DoCmd.SendObject acSendReport, "ReportName", "SnapshotFormat(*.snp)", _
"emailaddress.com", , , _
"Test Report", , False

The code seems to work OK, but I receive no email. I am using AOL, and have AOL active when I execute the code. I may be missing something here. Any help would be appreciated.

 

[TLady]

When I use Outlook I am Creating an Object:

Set olookApp = CreateObject("Outlook.Application&quot
Set olookMsg = olookApp.CreateItem(olMailItem) ' create the message.

I am sure in your case you should be creating object first

TIA

 

[hkaing79]

According to this thread,

http://www.tek-tips.com/viewthread.cfm?qid=623510

you can't.