I'm trying to send an existing Access Report as an attachment via MS Outlook. The SendObject method is not an option.

Since, the report i'm trying to send is an access object it is not stored at a particular path on the PC/network.

Any help would be greatly appreciated! This is what I have tried so far but have been running out of options...
Code:
Dim objOutlook As New Outlook.Application
Dim ObjOutlookMsg As Outlook.MailItem
...