PDFing and attaching a report

[cathywoodford]

Hi. I have a database that allows the user to search for a particular
field or view all fields. When the form opens with the correct
information, the user clicks the "Print" button to show them the print
preview screen and then from there they can print. I would also like
to have a "Send for Filing" button on the form that will automatically
save the report that should open as a PDF and attach in an e-mail....is
this possible?

Thanks,
Cathy

 

[Guest]

Cathy

Stephen Lebans has code to convert a report to a pdf file on his Web site
and Tom Wickerath has code to send attachments to e-mails but the code is
very complicated.

However, I have combined their code into a module which can be imported into
a database and then called with one sub-routine call. You just pass the name
of the report, the e-mail address, the Subject field text and the Body test
to the routine and the code converts the report to a pdf file, attaches it to
the e-mail and then passes it to the e-mail client program. If you would like
a copy just e-mail me, my e-mail address is in my Profile.

 

[cathywoodford]

Thanks Peter. I would like to have the code. Does it matter that a
different report must open depending on what the user searched for?

Can you just send the code to my e-mail address listed?

Thanks again.

Cathy

 

[Guest]

Dear Mr. Hibbs,
Mr. Hibbs,

This was exactly what I was hoping to established with my database and I
need your assistance. I sent you an e-mail but for some reason, it cannot get
through. It would be greatly appreciated if you would share with me your
module. Thank you in advance for your help.

Best regards

 

[Peter Hibbs]

Jae

Perhaps you could e-mail me at (e-mail address removed)

Peter Hibbs.