I am using Office 2007. I have a spreadsheet in which each row contains manager information (name, email) and corresponding employee information (name, email). Each employee is a unique row however some managers may appear in more than one row as they may have more than one employee reporting to them. I would like to create a mail merge of some type using this data where each manager would receive an email containing a generic message into which the names of their corresponding employees would be inserted. Is there any way to automate this?