How export PDF via email and make it a fillable form

SteveL13
SteveL13 used Ask the Experts™
on
I'm trying to figure out how to export an existing report to a fillable PDF and attach it to an email address.

Can this be done?  I've not worked with form PDFs before.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014
Commented:
You'd have to do this with a 3rd party PDF library like Adobe or something along those lines. The builtin libraries will only export to a standard PDF form.

You can export the report like this:

DoCmd.OutputTo acOutputReport, "YourReport", acFormatPDF

Note too that "exporting" a report to PDF often will cause some oddities in format and layout, so be aware of that.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015
Commented:
here is a link for a Fillable PDF Forms demo:

http://accessmvp.com/theDBguy/demos/fillablepdf.asp
Most Valuable Expert 2012
Top Expert 2014

Commented:
I believe that demo will fill the fields of a "fillable" PDF form, but it won't create one. As mentioned, the only way to do that is with a 3rd party utility.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
Scott, yes ... it is still a demo on how to do it though ...

Author

Commented:
Both very helpful.  Thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial