Access 2003

Hi Jason, thanks for your query.

First, here's a useful discussion on manipulating printer settings in Access VBA:

http://forums.databasejournal.com/showthread.php?t=51681

Note, the talk of the API at the end. It's difficult to give you specific advice because, of course, things can change depending on the set up but I doubt you'll need to go into manipulating the Printer API. Next, is a link to PDF-ing and emailing...

http://p2p.wrox.com/access-vba/54452-print-pdf-access.html

...which opens a whole can of worms. We go into manipulation of the Outlook object model on our Excel VBA course, but one of the key things to check is that withing Access you do actually have a reference to the Outlook object model. You do this using Tools-References within the VBA IDE.

See how you get on and let me know if you encounter any difficulties.

All the best,

Anthony