I print an invoice by opening a formatted Access Report that uses some "On Load" events to select appropriate graphics and notations on the invoice (different logos and such). I currently manually print this to PDF (via PDFCreator) and file the PDF in an "Invoice" folder, giving it the Invocie Number as it's docuemnt name, e.g. 12345.pdf I can then fire an email via VBA to Outlook and pick up the PDF version of the invoice from the Invoice Folder, attaching it to the email.
THis all works fine, but I would like to automate it a little more. Instead of manually printing the PDF file from the Access Invoice document, I would like to initiate the print via VBA and have VBA tell the system what folder to save the PDF to, and then create the email and attach the PDF Invoice.
I have most of the steps already in place, but can any one help me with the VBA code that will open the Access Report (the invoice), load the "on-load event items, print it to PDF (via PDFCreator) and save the PDF in a designated folder on the C:\Drive.
I have already ticked the PDFCreator item in the Tools - References section of the code window.