Access 2010 Report output to PDF + Email merge

Time to get with the times and move away from printing customer statements. Does anyone know of a way to output a batch of Access reports to individual PDF files specifying the customer's name for each. If I could do this as an email merge where the PDF files are sent out to each customer's email address as an attachment then even better.
John CarrollAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nick67Commented:
Output is fairly easy.
I have a folder called c:\tempPDF
This code renders the report, name passed in as a string, to PDF
[b]
Private Sub SaveAsOfficePDF(stDocName As String)
Dim FormatValue As String
If Application.Version > 11 Then
    FormatValue = "PDF Format (*.pdf)"
Else
    FormatValue = acFormatRTF
End If
    DoCmd.OpenReport stDocName, acPreview
    DoCmd.OutputTo acOutputReport, stDocName, FormatValue, "c:\tempPdf\" & Reports(stDocName).Caption & ".pdf"
    DoCmd.Close acReport, stDocName, acSaveYes
end sub
[/b]

Open in new window


Now, in your report, ensure that in the Open() event there is code to change the .Caption to a unique string.  The PDF takes the .Caption as its filename -- which you will need in the next step

Outlook can be automated
Open it properly, compose and address a message, and attach the newly generated PDF
http://www.experts-exchange.com/articles/17466/Properly-open-Outlook-as-an-Application-object-in-VBA.html

Then enclose the whole nine yards in a loop to do your batch.
Have a look here
http://www.experts-exchange.com/Database/MS_Access/Q_28673928.html
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Here's an excellent article by Patrick Matthews that shows how to automate Outlook, and includes a database to show you how:

http://www.experts-exchange.com/articles/4316/Automate-Outlook-in-VBA-with-the-OutlookCreateItem-Class.html
0
John CarrollAuthor Commented:
Thank you, will look at this over the next few days...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.