Ask a new question

Many to one Email mail merge

Working in either Word and Outlook 2010 or 2013 (I have two computers)

 

I have a simple premise where I need to email managers with list of their employees to confirm the employee will attend a seminar or not.

 

In excel I have the list of employees in each row. In the next columns I have their manager and their manager's email. I need to figure out how I can mail merge a list of the employees into one email per manager.

 

Example

 

Employee Manager Email
John Mike Smith *** Email address is removed for privacy ***
Mary Mike Smith *** Email address is removed for privacy ***
Joe Mike Smith *** Email address is removed for privacy ***
Rachel Mike Smith *** Email address is removed for privacy ***
Mike Mike Smith *** Email address is removed for privacy ***
Kumar Jane Audry *** Email address is removed for privacy ***
Tyler Jane Audry *** Email address is removed for privacy ***
Sam Jane Audry *** Email address is removed for privacy ***
Jenna Jane Audry *** Email address is removed for privacy ***
Larry Larry Sergar *** Email address is removed for privacy ***
Bob Larry Sergar *** Email address is removed for privacy ***
Kristen Larry Sergar *** Email address is removed for privacy ***
 

 

Then I need the email to look like:

 

Mike Smith,

 Please confirm the following list of employees will be available for the seminar Tuesday

 

    John

    Mary

    Mike

 

Regards,

Company's CSC

Answer
Answer
You could use Graham Mayor's free add-in Many-to-One.
---
Best wishes, HansV
https://www.eileenslounge.com

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated September 12, 2022 Views 577 Applies to: