Print to a selected printer and email screen shot

[tarena]

I am using Access 97. I want to set a control button to automatically print the selected form to pdf (the printer name is pdf995) and then email the pdf to certain users using outlook 2003. Can I do this and how?

Thank you
Tarena

 

[jrbarnett]

Yes - you can do this. Please be aware that Tek-Tips is a community of IT professionals, we are not here to solve your own IT problems for you.

It requires a bit of VBA programming on your part. Here are two snippets that should help you:

1) PDF995 code to print to a PDF file automatically

http://www.freeware995.com/misc/vbacode.txt

2) For links relating to sending email from an Access database, see thread702-1475133

John

 

[tarena]

Thank you very much for your assistance jrbarnett.