If you are going to try mail merge. Then open the document. From the Mailings tab - Select Recipients and select your worksheet. Insert fields in the document as appropriate, that reflect information that you wish to display from the worksheet.
Save the document. Edit Recipient List. Uncheck everything except the record you want to merge. Finish & Merge > Edit Individual Documents and you will get a new document with the data merged.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
|