print to pdf in code

[Jill]

I am using MS Access 2000 on XP.

I would like to email a series of reports as pdf
attachments (using a module). I have figured out how to
email an attachment and how to print to pdf. However PDF
must be the default printer and a dialog box asks me to
name the pdf file for each report. I have two questions:

1. Is it possible to dynamically name the pdf that you
are sending the report to (from within a module)?

2. Is it possible to change the default printer in code?

Any help would be greatly appreciated.

Thank you,
Jill

 

[SA]

Jill:

Access doesn't natively support PDF creation as you've found. You might
look at our PDF and Mail Library for Access which supports PDF creation from
Adobe drivers, Win2PDF, pdfFactory and PDF995. With it you can create your
PDF via code (including output file) and then mail it using Outlook, Outlook
Express, Lotus Notes or Group Wise. You'll find it on our web.

HTH

 

[Guest]

I downloaded the trial version and it works wonderfully!

Thank you!

Jill