Joined
·
2 Posts
I was looking for some help with writting a merge field.
I have an excel file with information broken out by person in rows. some are married and some are single, the married people need to be on the same letter. e.g.:
Mary Smith
Paul Smith
Larry Johnson
Ray Jones
Sue Jones
First and last names are in separate cells
How do I code the word file with the merge fields to get Mary & Paul Smith on one letter, with only 1 last name, Larry Johnson on a 2nd letter, & Ray and Sue Jones on a 3rd, etc.
I'm guessing some kind of skipif code, but am not sure how to write it.
Thank you in advance for any help!
I have an excel file with information broken out by person in rows. some are married and some are single, the married people need to be on the same letter. e.g.:
Mary Smith
Paul Smith
Larry Johnson
Ray Jones
Sue Jones
First and last names are in separate cells
How do I code the word file with the merge fields to get Mary & Paul Smith on one letter, with only 1 last name, Larry Johnson on a 2nd letter, & Ray and Sue Jones on a 3rd, etc.
I'm guessing some kind of skipif code, but am not sure how to write it.
Thank you in advance for any help!