attach report to email

[pleasehelpalot]

Does anyone know of a way to directly attach an access report to an existing email?

thanks for any help

 

[teqtaq]

You have to Create an object depending on what type of email you are using.
Let's say Create Outlook Object and go from there.
I do not have an example of the code but it is a start.

Good Luck!

P.S. I am pretty sure you have to Print your Access Report into .pdf or Excel file and save in the directory.
When Outlook Object will be created and opened - you will point it to the directory where Report is saved and it will attach it to itself (Outlook I mean)

 

[pleasehelpalot]

I was hoping to drag it over but I guess that's not going to happen

 

[teqtaq]

You can save it as .pdf using VBA code.
Reaqd

http://www.lebans.com

- it tells you everything how to automatically save Access Report as .pdf file.

 

[pleasehelpalot]

I realized if I preview it I can then save or print it as.pdf and then attach it to the email. Works good and the user is satisfied. The key was creating the .pdf so thanks for pointing me in the right direction.