Brad Marks
BradM at blackforestltd.com
Wed Nov 17 18:42:13 CST 2010
John, I have set up several Access reports that are automatically run and emailed as attachments each night. Here is the gist of how this works. The Windows scheduler fires up a macro in an Access application which in turn initiates VBA code. The VBA code establishes the file name for the PDF file. (The file name includes a date/time stamp.) The VBA code then runs and exports the report to the PDF file. The file name of the generated PDF file is then passed to a "Command Line Emailer" which sends the email with the PDF file as an attachment. This process was set up about 6 months ago and has worked successfully every night since. I am not sure if this helps with your question. If you need more details about any of the steps, please let me know. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com on behalf of jwcolby Sent: Wed 11/17/2010 2:17 PM To: Access Developers discussion and problem solving Subject: [AccessD] Automating pdf printer A client wants to print stuff to a pdf and send the email. I would create a report and send it to the printer, then pick up the resulting file and send an email. I know how to do everything except the pdf part in the middle. Is anyone doing this? -- John W. Colby www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.