Solved

How do I mail merge a group of entries intended for a single recipient?

Posted on 2014-10-17
2
86 Views
Last Modified: 2014-10-23
In this scenario I have a list of servers and the people who built them.

The fields that are relevant from the data data is as follows. Server,Description,BuiltBy,E-Mail,Note

So I can perform a mail merge that will be sent to each person that built the server(s) (BuiltBy) to their Email containing the details of the Server,Description,Note contained within the data for each server that matches them.

The idea behind this, is that I can flag servers for audit on a separate system and format the data in this way. It can then be mail merged for convenience.

Is this a simple process?
Letter.docx
Servers.xlsx
0
Comment
Question by:tegenius
2 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40386580
Hi,

You could use the add-in from Gmayor

http://www.gmayor.com/ManyToOne.htm

Regards
0
 

Author Closing Comment

by:tegenius
ID: 40399561
After reading the instructions carefully, I was able to get this working on windows 8. Cheers.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question