View Single Post
 
Old 06-06-2017, 01:15 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Chances are that you don't have the data sorted by School.

This is a many to one mail merge.

Modify the document as attached and download http://www.gmayor.com/ManyToOne.htm re-attach the data source and set the merge type as Letters.

Sort the data by the School field. School is thus the Key field. The fields LastName, FirstName and Decision are the Child fields.

You can then produce your letter in a variety of ways.

If you want the contact field inserted as a hyperlink then see also http://www.gmayor.com/hyperlink_merge_fields.htm
Attached Files
File Type: docx decision letter_public.docx (14.7 KB, 12 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote