Solved

Email Access Report using PDFCreator and Outlook

Posted on 2009-04-11
5
689 Views
Last Modified: 2013-11-28
Hello

I want to have a email button on a form, this will automatically email Access report as a PDF using Outlook.

Only way I can think this can be done is to use PDF Printer (I have chosen to use PDFCreator) and save PDF file into the folder.  Next step is to email this PDF file using Outlook.

Can you please provide VBA code to do this.

ps. I used  SendObject to HTML, this worked fine, but I loose too much of the formatting, also it prints multipages reports into multiple HTML files and what I really need is PDF files I can send to customers.

Access Version 97
0
Comment
Question by:Pekka_Anttila
  • 2
  • 2
5 Comments
 
LVL 3

Expert Comment

by:SimonThompson
ID: 24125034
Have you considered attaching the report as a snapshot?
0
 

Author Comment

by:Pekka_Anttila
ID: 24125442
I am sending these reports to 700 customers, so it is not practical.  I wan' them to be able to open file without getting extra software and without any hassle.  PDF is the best in this case, everybody can open it and it will retain all formatting.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 24126249
Pekka_Anttila,

The brevity of your question belies its complexity.

Asking how to send an email is like asking how to build a house.
;-)

Questions:
How is you db structured
Where are the email addresses
What is your skill level with VBA
How do you determine who get the email
Do you want to see the email first or just send it.
Is this report to be filtered?
What version of Access/Office/Outlook are you using?
...ect

If you are using Access/Office/Outlook 2007, this is easy:
DoCmd.SendObject acSendReport, "ReportName", acformatPDF, "EmailAddress", , , "Subject", "MessageText"

If you need this in Office 2003 then you may have to do some filtering and or looping.

So,

Can you please explain, step by step, how you want this system to work.

Ex:
User opens the form.
User_____________
Then the user___________
Then they click__________
Then_________
Then an email ____________
...ect


If you just need a generic example of how this could be done using third party software, try this, it is based on the code found here:
http://www.lebans.com/reporttopdf.htm

JeffCoachman
Access-BasicConvertReportToPDFAn.mdb
0
 

Author Closing Comment

by:Pekka_Anttila
ID: 31571921
Hello
I used lebans code, worked perfectly on the A97

Thanks
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24178063
Great!

Congratulations!
;-)

Jeff
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now