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

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Automatically PDF and send?    
 
   
paulgreen
post Feb 7 2007, 06:10 PM
Post #1

UtterAccess Enthusiast
Posts: 86
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.
PG
Go to the top of the page
 
+
Aquadevel
post Feb 7 2007, 06:19 PM
Post #2

UtterAccess VIP
Posts: 6,902
From: Earth...



Pg,
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
Aqua
Go to the top of the page
 
+
GroverParkGeorge
post Feb 7 2007, 06:35 PM
Post #3

UA Admin
Posts: 22,939
From: Newcastle, WA



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

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

UtterAccess Enthusiast
Posts: 86
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
 
+
hine
post Feb 20 2007, 10:09 AM
Post #5

New Member
Posts: 1



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
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 20th December 2014 - 10:04 AM