If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automatically email report in PDF format
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? |
#2
|
|||
|
|||
Automatically email report in PDF format
On Jul 13, 10:20 am, Sara wrote:
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/micro...83609aabab5b/# http://groups.google.com/group/micro...1f0cf641?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 |
Thread Tools | |
Display Modes | |
|
|