I have an access database which sends an email to a person in a recordset. But it all works, has the body and everything the only thing i want to add is an attachment. I can add a file but not sure how would i add a report from my database. Here is as far as i got:
OutlookMessage.Attachments.Add "C:\EmailSend.mdb", Reports!rTest, , "hi"

rTest is the name of my report.
Any help is great THanks a lot

Maybe there is a way to add the report to the body of the email. Anyone have any ideas?

Havn't played with the code to do this, but you could look at saving the report as a Snapshot (.snp) and sending the snapshot file as an attachment.

Bob