Sending out a report

[ChristopherL]

Hey..
I am not a great VBA writer, but I believe this easiest could be solved with VBA..
If it's not to hard for you mby someone can help me?

I want a macro that sends out two reports with subject "Counterparty Price Report As Of =Date()"

And I want the attatched report be sent out as a .pdf file with name Counterparty Price Report As of =date().pdf

Is this possible?

Regards,
Christopher

 

[pr2-eugin]

ChristopherL, you can check the DoCmd.SendObject method to send out the report in a PDF, although if you wish to rename the file.

I think you need to first export the report using DoCmd.OutputTo then use the VBA code to send email out.