Thanks for this code, it looks too 'scary' for me. Am I right in thinking this code attaches an Excel Doc for emailing? I need to attach 2 Access Reports.
Rob's code nearly works. I just need to set the variable for the Report. Not sure how to do this, any ideas
Thanks
Julie
Hi Rob
Thanks for this but I dont seem to be able to set the Report variable. I put:
Dim pname As Report
Set pname = name of report
Do I need to set the report as an Object, eg:
Dim appAccess As Object
Set appAccess = report
Regards, Julie
Is it possible to send 2 reports as attachments to Outlook from Access 2007.
I usually use SendObject, but this only allows for 1 attachment.
Thank you
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.