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

email as a pdf 1
Email PDF Invoice 2
Email form as PDF using Lotus Notes 6
Emailing multiple reports in Access 0
Fill a PDF Form with Access? 3
FIlter, Export & Email 2
Import Adobe LiveCycle Designer ES PDF Form 2
Sending pdf as attachment 1

Top