X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Automatically PDF and send?    
post Feb 7 2007, 06:10 PM

Posts: 89
Joined: 9-February 05
From: Wales, UK

Hi to all, firstly, we have Adobe Acrobat 7 on two machines, I can buy more licences if required if this works. I can also get a shareware or freeware PDF writer if one will make this easier.
That I want to do is print a file as a PDF to a certain filename (embedded in the file), I then want to trigger an email to be sent with some HTML blurb around it to send the email. Is this possible? I can use Redemption for the second part, but some help on embedding commands for Acrobat if this is possible.
Your help is appreciated.
Go to the top of the page
post Feb 7 2007, 06:19 PM

UtterAccess VIP
Posts: 6,902
Joined: 8-August 05
From: Earth...

Take a look at WWW. Lebans.com's ...........'Report2PDF Demo/code.
It will convert an Access report to *.Pdf, and yes you can name/place it wherever you want on creation.
<Did I mention its also 'free'>?
IMHO, since I just get 2 1/2 cents, its worth every penny! sad.gif
Good luck, sad.gif
Go to the top of the page
post Feb 7 2007, 06:35 PM

UA Admin
Posts: 28,915
Joined: 20-June 02
From: Newcastle, WA

Here's a demo that uses Redemption and Stephen Leban's PDF Generator

Edited by: GroverParkGeorge on Wed Feb 7 18:35:30 EST 2007.
Go to the top of the page
post Feb 7 2007, 06:39 PM

Posts: 89
Joined: 9-February 05
From: Wales, UK

Thanks to both, I'll get this going tonight and show it off to my team in the morning. Thanks again.
Go to the top of the page
post Feb 20 2007, 10:09 AM

Posts: 1
Joined: 20-February 07

to send a Report as PDF you may consider to use ac2007 and SendObject
DoCmd.SendObject acSendReport, strReportName, acFormatPDF, _
"Nancy Davolio; Andrew Fuller", "Joan Weber", , _
"Current Report of Employees", , , True
For write to file
DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, "C:\temp\Report.PDF"
but I never managed to do html emails..........
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    29th March 2017 - 12:08 PM