H
hughess7
Hi all
I have a report I want to send via email as a PDF. I have a routine which
will do this from a form - the report is set to print to the PDF printer
driver and my code prints the report from a docmd.openreport statement then
attaches the newly created PDF to an email.
I want the user to be able to preview the report though first and then have
the option to print on close but I can't get it to work. I tried calling my
routine from the OnCLose event of the report but Access doesn't seem to like
the docmd.openreport statement within a close event. I can obviously add
another button to the form that calls the report preview just to email the
report but I was wondering if I could do this from the one button somehow?
Thanks
Sue
I have a report I want to send via email as a PDF. I have a routine which
will do this from a form - the report is set to print to the PDF printer
driver and my code prints the report from a docmd.openreport statement then
attaches the newly created PDF to an email.
I want the user to be able to preview the report though first and then have
the option to print on close but I can't get it to work. I tried calling my
routine from the OnCLose event of the report but Access doesn't seem to like
the docmd.openreport statement within a close event. I can obviously add
another button to the form that calls the report preview just to email the
report but I was wondering if I could do this from the one button somehow?
Thanks
Sue