Send seperate parts of a table to individual email addresses

[evans502]

Hiya Guys,

Is there a way in EXL 2007 to automatically send an email out to a number of people, seperating the rows of the table that relates to that email address?

To clarify: We extract a table of results from a system that includes individuals email addresses, and send a standard email containing only the rows that relate to them. The only problems is we have around 200+ members of the company to send emails to.

I understand we could use something similar to mail merge in Word, but it would be confusing if they had the whole spreadsheet!

Cheers for the help!

Rich

 

[obiron]

Best bet would be to produce a pivot table and use VBA to change the paging criteria, copy the table, pastespecial->values and then either embed the table in the email body or save as a workbook and attach to the email.