Save/Email PDF (old)

This wizard lets you save an Adobe PDF copy of the Excel workbook, and optionally email it to someone. Email options include SMTP email or Google Gmail.


Same Folder – save the PDF file in the same folder as the original.

Default Report Folder – click the Set button to establish a default report folder that can be used in multiple reports. This allows you to keep copies of all your PDF reports in one place.

Custom Folder – click the Set button to select a folder for this one report, or enter it manually in the space provided.


Same File Name (+ Date) – save the PDF to the same name as the original workbook, but with a date and PDF extension instead of the XLSX extension.

Filename – save the PDF to a specific filename. A ‘.pdf’ extension will be added if you do not include it.

Append Date – optionally adds the current date to the file name. This allows you to use a custom file name that includes a current date component without editing the function each time. Optionally change the format codes for the date. See Date Format Codes for details.

Send as Email Attachment

Do not send – do not send the saved PDF file via email.

Gmail – select the Google account to use or click the Add button to login to a different account. Note that the Google accounts are managed in the Options wizard.

SMTP – send the email via the SMTP account configured in the Options wizard.

To – enter the email addresses to send the attachment to. Optionally blind copy yourself by checking the Bcc me box.

Subject – subject line for the email

Msg – body text of the message. If you want to use HTML formatting, check the HTML box.

Updated for v10.