Sending Access Reports using Outlook

[MordyJoe]

I would like to send reports from access VBA using outlook. I used to use Thunderbird and the docmd.sendobject where i just had to put in the report object name without first creating a report file. I know how to create a report file then attach it to outlook. I'm looking to see if it is possible to send the report directly without creating the report file.
I'm using Access and outlook 2007.
One more question. Is it possible to use the docmd.sendobject with outlook?
Any help would be greatly appreceated.

 

[PHV]

The SendObject method uses the DEFAULT mail agent.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MordyJoe]

I was trying to get outlook to be the default mail agent, not knowing if that would help. Now I know it is worth continuing down that road.
So I take it that if I use the outlook application directly I'll have to create a file and attach it.
Thanks for your help. I spent HOURS looking for a way to do it. Now I can get back to work!