[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