Question Locked

Writing contracts with Excel and Mail Merge

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!

1 reply

This discussion is closed to new replies.