S
socasteel21 via AccessMonster.com
I have created a database for quoting machine prices to customers. I have a
report that shows the machine quote. As it is right now, I have a button
that opens Microsoft Outlook with the report attached to the e-mail message
in the format that I have specified in the options dialog box that Access
opens. I would like to be able to press a single button and have Access do
the following:
1. Change my default prrinter to Win2pdf (which I have installed).
2. Save the pdf file to a 'temp' folder and another copy to an archive with a
smart file name (i.e. Quote #.pdf).
3. Print 2 copies of the report.
4. E-mail the pdf file from the 'temp' folder.
5. Delete the file from the 'temp' folder.
6. Change my default printer back.
I need some VBA code to past in the OnClick event of the button to acomplish
this.
Thanks in advance for any help.
Shannan
report that shows the machine quote. As it is right now, I have a button
that opens Microsoft Outlook with the report attached to the e-mail message
in the format that I have specified in the options dialog box that Access
opens. I would like to be able to press a single button and have Access do
the following:
1. Change my default prrinter to Win2pdf (which I have installed).
2. Save the pdf file to a 'temp' folder and another copy to an archive with a
smart file name (i.e. Quote #.pdf).
3. Print 2 copies of the report.
4. E-mail the pdf file from the 'temp' folder.
5. Delete the file from the 'temp' folder.
6. Change my default printer back.
I need some VBA code to past in the OnClick event of the button to acomplish
this.
Thanks in advance for any help.
Shannan