Mail merging and pulling varying data from Excel
Hi All,
I'm new to the forum, but not new to Office, and I normally find that I can easily figure out how to do stuff, but this one has me stumped.
I have a big spreadsheet with information I need to send to various people, however, not everything needs to go to everyone, but multiple rows of information need to go to the same person. For example, Ms. A needs to receive the info in rows 1-6, Mr. B needs to receive the info in rows 7-9, Ms. C needs the info in rows 10-22, etc.
I know I can sent up an email merge and send each rows info as it's own email, but that will result in people getting multiple emails and I don't want that.
Any suggestions?
Shanna
|