Insert a key for each person

[bblelli]

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.