Dears,



I would like to express my gratitude. You guys are helping me a lot!

And now, here comes another doubt.
I have a very confidential report (word document) to distribute to 15 different people.
In an Excel Spreadsheet I have the name of each person and an individual key to be used for each one. Please, check the picture below for your understanding.



I want to create a code that creates 15 versions of my confidential report, each one with the individual key written at the botton left side (footer) of each page of my confidential report. Please, check the picture below for your understanding.



Note: I don't want the name written anywhere, I just want its code.

At the end, the the code must save the file with his name.

How can I do that?
I really appreciate any kind of help.

Thanks a lot.

Attached Images

	Excel.jpg (14.8 KB, 11 views)
	Word.jpg (25.5 KB, 11 views)

I would use mailmerge for this. E-Mail Merge Add-in will create the 15 documents, using your worksheet as a data source.

Add the Key merge field where you want the identifier number and use the Person field to name the document.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com