print to pdf in code

  • Thread starter Thread starter Jill
  • Start date Start date
J

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
 
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
 
Back
Top