Access VBA - automatically converting a report to PDF and emailing

Hi

What Access VBA code would I use to automatically generate a report?

Thanks
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
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.

Dale FyeCommented:
not sure what you mean by "automatically generate a report"?

You can design a report by creating a query, then using the report wizard to create the report, but I've never heard of "automatically generate a report".

Or do you just want to run a report from a command button?  If this is what you had in mind, you can either use the control wizard when adding a command button, or write the code yourself.  If this is what you had in mind, post back.
0
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
I found the following code. I want to convert an open report called "Invoice" to a PDF file then email it
from any email system

DoCmd.OutputTo acOutputReport, "Invoice", acFormatPDF, myFileName
0
Dale FyeCommented:
I'm not sure whether the SendObject method works with "any email system", but that I would look at the examples associated with that method in Access help.  If that doesn't work for you, then search in EE solutions on SendObject.  You will find lots and lots of posts on that subject.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

JAndreassenCommented:
I use this command to send a report as PDF from my Outlook and it works perfectly. Just have to allow Access to use Outlook, a popup box.
0
Jeffrey CoachmanMIS LiasonCommented:
Then do this:

DoCmd.SendObject acSendReport, "YourReportName", acFormatPDF, "SomeEmailAddress", , , "SomeSubject", "SomeMessage", False


This presumes Access 2007 with the PDF add in installed.
0

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
Jeffrey CoachmanMIS LiasonCommented:
Also remember, that in Access 2007, ...when the report is open you can click:
Office Button-->Email-->PDF Format

JeffCoachman
0
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much. If I am going to install my application on other people's machines then is using PDF the best option?
0
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks very much
0
Jeffrey CoachmanMIS LiasonCommented:
<I found the following code. I want to convert an open report called "Invoice" to a PDF file then email it
from any email system>

...Sorry, I just read this...

If you want to email with "Any email system" you will have to use any of the available "Emailing" programs:
CDO:
http://www.google.com/#hl=en&q=VBA+Microsoft+Access+cdo+email&aq=f&aqi=&aql=&oq=&gs_rfai=&fp=8631cdd35a4d476d

FMSINC:
http://www.fmsinc.com/MicrosoftAccess/Emails.asp

There are others as well, do a search here or on google.

;-)

JeffCoachman
0
Jeffrey CoachmanMIS LiasonCommented:
<Thanks very much. If I am going to install my application on other people's machines then is using PDF the best option?>
Probably, as most people have Acrobat loaded on their machines already.
Also, under normal circumstances, a PDF cannot be edited.
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.