Solved

Email Access Report using PDFCreator and Outlook

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

820 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