Method to identify printer for docmd.printout

[news2]

I would like to send a report automatically via e-mail. I can do this if I
select one of the available formats (XLS, etc) but I would like to direct it
to a pseudo-printer to create a PDF file. I have found no way to have Access
identify a printer (other than the default printer). If a module exists to
identify a specific printer as default that would be nice - I could switch
to, printout, switch back. Or if there is a way to have the printout go to a
PDF format that would be a very good solution.

I'd like to avoid the need for the user to manually shift default printers,
do the print to it, then send it as an attachment in an e-mail.

 

[Peter Hibbs]

If you are using Microsoft Outlook to send your emails I can provide
you with some code that emails Access reports as PDF files. Contact me
at :- peter dot hibbs at btinternet dot com
if you are interested.

Peter Hibbs.