I wonder if anyone in the room has already created a VBA for a similar scenario below: I have a pivot table containing fields that I need to copy and paste to the middle part of the body of an already existing Outlook Email template (another option is to have the pivot table as a PDF attachment) The pivot has a Vendor filter Each vendor has unique pivot table entries Each vendor has unique corresponding TO, CC and BCC email addresses maintained in a separate sheet Each vendor has unique email subject The automation has to send separate email per vendor The automation will stop if all emails are created (no automatic sending as manual review has to happen) Formatting of the email template should not change (color, font size, etc.)

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA for Copying Pivot Table Entries to an Existing Outlook Email Template

I wonder if anyone in the room has already created a VBA for a similar scenario below:

I have a pivot table containing fields that I need to copy and paste to the middle part of the body of an already existing Outlook Email template (another option is to have the pivot table as a PDF attachment)
The pivot has a Vendor filter
Each vendor has unique pivot table entries
Each vendor has unique corresponding TO, CC and BCC email addresses maintained in a separate sheet
Each vendor has unique email subject
The automation has to send separate email per vendor
The automation will stop if all emails are created (no automatic sending as manual review has to happen)
Formatting of the email template should not change (color, font size, etc.)