email report as pdf using macro on Form?

D

Dave Ganesh

I have a form which I would like to email right away keeping the same format
as shown in MS Access databse. Currently, I print and save as PDF file using
PDF Creator installed on my PC. Then I email the form to the Customer.

I wanted to place a button on the Form which I can click and using a macro
for instance, I can email the form as a PDF right away. The Macro in the
database currently only has SendObject as .txt or xls. formats which converts
the form to a different view all together.

How do I get this button to email instantly to the recipient in the pdf
format from the Form in Access database?? Any siggusetions, please note that
I am not an expert at MS Access and VB codes.

Thanks.
 
T

Tony Toews [MVP]

Dave Ganesh said:
I have a form which I would like to email right away keeping the same format
as shown in MS Access databse. Currently, I print and save as PDF file using
PDF Creator installed on my PC. Then I email the form to the Customer.

I wanted to place a button on the Form which I can click and using a macro
for instance, I can email the form as a PDF right away. The Macro in the
database currently only has SendObject as .txt or xls. formats which converts
the form to a different view all together.

How do I get this button to email instantly to the recipient in the pdf
format from the Form in Access database?? Any siggusetions, please note that
I am not an expert at MS Access and VB codes.
Click to expand...

You'll need to learn some VBA. There are a number of solutions at
Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To make pdf to work as word 1
VBA Export to PDF 0
Convert PDF to Visio File or Editable PDF in Visio 0
Using Access Database to build contracts with fields on pdf document 0
Dynamic Naming of Form Button 3
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
send form as pdf from access with the click of 1 button? 0

Top