What is my best way to accomplish the following with Office

Hi,

I am a wedding professional, and have to keep track of a lot of client info about a wedding.
Names for Introductions, songs, etc...

I want to use a spreadsheet, or word to input all of the data, and then create a word document of it to show a client.

Though a few things, I want to use some formuilas
In my excel document
Acknowledge field is 1 then it will go under Acknowledgements section of word doc
If the name section is blank, like Parents of The Groom is, it won't be addded

Then use the variables tab in the excel doc, to show the info for the bridal party

What is the best way to accomplish this? Is Word and Excel the best method or is using a other program?

Any opinions or tips is well appreciated.

Thanks!
Names.xlsx
Should-look-like.docx