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.