Solved

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

Posted on 2014-10-17
2
80 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 49

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
I tend toward trying the newest hardware and software.  Thiss sometimes works out to my benefit, and sometimes not.  Because I downloaded and installed Android 5.x (http://www.experts-exchange.com/articles/18084/Upgrading-to-Android-5-0-Lollipop.htm…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

862 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now