Greetings. I’m using Mail Merge to set up some contracts, and I’ve run into a problem I can’t seem to get around.
The deals have a varying number of guarantors. Each guarantor can be an individual or a company. So, I have set up column headers Guarantor 1, Type, Guarantor 2, Type, …, up to Guarantor 10.
Now, the contracts have to have a place for the guarantors to sign, which looks like this:
(For Individuals:)
John Doe, individually, as Guarantor
By: ________________________
Name:_______________________
(For Companies:)
Acme Corp., as Guarantor
By: ________________________
Name: ______________________
Its: _______________________
So, as you can see, both are a little different.
My question is: Can I set this up so that Word can pull how many guarantor signing spaces we need, the names of the guarantors, and adjust for the formatting and wording for individuals and companies?
I know it seems like a lot, but if it works, it would really pay off in the end. It’s like a brain teaser I’m trying to crack!
I’ve tried If…then…else, but it doesn’t seem like it can input data from the data source with that.
Thanks for any help!
