Automatically email report in PDF format

[Guest]

Hi, I am using a db somebody else created; this db uses macros to send the
20+ reports to outlook users. My boss would like to have those reports
attached as PDFs instead of the regular snapshot format.
I have found information on software like CutePDF, and Leban’s ReportToPDF
module (www.lebans.com) but with either one it seems that the user has to
select the report and then it gets stored in a folder from there the user
has to manually attached in the email. With 20+ reports that have to be sent
daily it would take to long.
Is there a way to automatically convert all the reports that are in the db
to PDF and automatically attach them to e-mail, like using the action
“SendObject†in a macro.

I think I've read in one of the posts that Leban's code + some modifications
is supose to do that. I guess I don't understand the code very well (total
newbie in VBA), therefore I am not sure what to modify, Could someone please
help me or suggest other approach?

 

[krissco]

Hi, I am using a db somebody else created; this db uses macros to send the
20+ reports to outlook users. My boss would like to have those reports
attached as PDFs instead of the regular snapshot format.
I have found information on software like CutePDF, and Leban's ReportToPDF
module (www.lebans.com) but with either one it seems that the user has to
select the report and then it gets stored in a folder from there the user
has to manually attached in the email. With 20+ reports that have to be sent
daily it would take to long.
Is there a way to automatically convert all the reports that are in the db
to PDF and automatically attach them to e-mail, like using the action
"SendObject" in a macro.

I think I've read in one of the posts that Leban's code + some modifications
is supose to do that. I guess I don't understand the code very well (total
newbie in VBA), therefore I am not sure what to modify, Could someone please
help me or suggest other approach?

I'll assume you are using Outlook.

Here are two posts within the last two weeks that will help:
http://groups.google.com/group/micr...ports/browse_thread/thread/de0283609aabab5b/#
http://groups.google.com/group/micr...s/browse_thread/thread/3dd8386d1f0cf641?tvc=2

I now re-read you post and see the words "newbie in VBA" - we were all
there once.

What you will need to do is create your own function to send a batch
of reports as PDF. Under the Modules tab, create a new module. Inside
of that module, you will create a function like so:

public function exportMyReports()

'Code goes in here

end function

As your "Code goes in here" section, you will need code to do the
following:
1. Export the report as a .snp file
2. Build a .pdf from the .snp
3. Create an e-mail and attach the .pdf. Send the e-mail.
4. Repeat for the next report


Read those previous posts and determine the best way to accomplish
this for your application.

Good Luck,

-Kris