[AccessD] access report to pdf to email in VBA

There is a report to pdf utility on Stephan Lebans site that can be used to
create the pdf file. You can take those and email them.

http://www.lebans.com/reporttopdf.htm

Doug 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Turner
Sent: Wednesday, September 03, 2008 2:19 PM
To: accessD at databaseadvisors.com
Subject: [AccessD] access report to pdf to email in VBA

  

Hello list,

I searched the archives but didn't quit understand any solutions. We have an
Access report written in VBA where we use acFormatSNP to write the report to
a SNP file and it emails the report to each person it needs to. We were
wondering if Access now had the capability to write a report to a PDF file
so it could be emailed automatically as the SNP file is. We use Access 2K at
the moment. This code creates the SNP report. Any suggestions?

CREATE THE REPORT IN TEMPORARY FOLDER

        strTempReport = "C:\Temp\EmailReport.snp"

        DoCmd.OutputTo acOutputReport, strDocName, acFormatSNP,
strTempReport, 0

        DoEvents

 

Steve A. Turner
Controller
Mid-South Engineering Co. Inc
P.O. Box 1399
Hot Springs, AR 71902
E-Mail: sturner at mseco.com and saturner at mseco.com
Phone:(501)321-2276
Fax:     (501)321-4750