Solved

Email Access Report using PDFCreator and Outlook

Posted on 2009-04-11
5
719 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

627 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