send parts of pivot table to different email addresses

[meaganmg]

Hello, I have a spreadsheet that contains multiple rows of data for various vendors. I have a pivot table that separates them out, and I want to send an email with the information to each of the suppliers without the others seeing. What is the best way to do this? The email addresses are listed in the last column of data. I have been just copying/pasting/hiding from the table into outlook, but it takes way too long with 50+ emails to send. Thanks in advance for any advice/tips/help you can offer.

[AYData]

http://office.microsoft.com/en-au/wo...102809678.aspx

Just use Word Mail Merge and set it up via that.

[meaganmg]

Can I use a whole tab as part of the merge? There is basically a whole table of information I want sent to each receiver. Haven't figured out how to do that with a mail merge

[AYData]

That page link provides a lot of information on mail merge page setups, so suggest read through it and related pages via links on the page (ie: one of the links takes you to http://office.microsoft.com/en-au/wo...in=HA102811941 ) which provides further information that you might need.