Split Table and Email out (Windows, Outlook)

[Cynops]

Hi All,

I am in need of some help, I have a report which included a table, on this table is a Unique code for which is a "timesheet of hours worked"

from this report I want to email the individual codes "timesheets" to the relevant persons? any format will do, ideally a TIF?

should have 5 images emailed out

Any help would be appreciated!

[dflak]

This program processes the time sheets by email address. To get a unique list of email addresses, I use a pivot table. I overlay this with a named dynamic range that the code loops through to process the list.

For each email, I clear the Time Sheet table, filter the data, copy the filtered data into the table, remove an extraneous column, save the Time Sheet tab as a PDF and mail the PDF.