Automate email pdf reports

[Guest]

After spending a couple of days reading all the posts about saving and
emailing reports to pdf, I'm still not too clear on how to automate the whole
process with a click of the button:
to email a report in pdf format to different people. I have the Cutepdf
installed and working, i.e., manually opening the report and going to File \
Print to convert to pdf file. I also can send an email with a click of a
button (using Late Binding without Ms Outlook or other MAPI client)
But how can I tie the loose ends and do both with one click of a button? has
anyone done this before and would like to help us out? thank you in advance.

 

[Guest]

I can tell you what I did
1. Create a directory in c drive called ReportTemp
2. The function I created includes 3 stages
2.1 Delete all files from the above directory
2.2 Create the pdf's for all the reports I need to send, in the temp directory
2.3 Open Mail, and add to the mail all the fiels that are in the temp
directory

I hope it gives you some idea, for me it works greate

 

[Guest]

Hi Ofer,
How do I go about creating the function for steps 2.1 and 2.2 -
automatically creating the pdf files? Can you share some sample codes, if
you have any?
I think I can send the email with the pdf attachment in a function.
thank you so much.

 

[Guest]

To create pdf files:
==========================================
Prev post given by: Arvin Meyer

I use Steve Arbaugh's PDF and Mail Class which does work with Adobe, but is
significantly faster and less error prone with Win2PDF

http://ourworld.compuserve.com/homepages/attac-cg/

http://www.win2pdf.com/

===============================================
Or

Take a look at http://www.granite.ab.ca/access/pdffiles.htm.
or
The snapshot format includes a viewer you can send with
your report the
first time (for those who don't have Access) There are
several free pdf
creators available too. Just google for: CutePDF or PDFCreator

There are several. You'll need GhostWriter and the print
driver. Have a look
at http://www.cutepdf.com for one of them. Others at:

http://www.pdf995.com/
http://www.primopdf.com/