Solved

Email Access Report using PDFCreator and Outlook

Posted on 2009-04-11
5
699 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

832 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