Hi Excel, I have a difficult coding problem that I need some help with. My company has accumulated a giant excel spreadsheet list of potential clients and we are trying to send them personalized letters depending on how large their presence is (how many times their name and address appears in consecutive rows). This is essentially a Mail Merge, but we have set up our format in the visual basics a little differently. Basically, we want to have 1 word document (letter) that will slightly change if a name/address combo appears once, 2 or 3 times, or 4+ times in the excel spreadsheet. However, the big change is when the combo appears 4 or more times because at that point, we want the letter to create an "Exhibit A" that will display all of the information in a different format. Its a complex if/then situation that I have never done. Maybe it needs an additional sub? Generally, the letter will stay the same, keeping the same wording for the first 3 paragraphs. However, after those paragraphs, we would like to add a new paragraph and alter the closing paragraph, in addition to creating the Exhibit A. I'm sure my explanation has left a few unanswered variables, but this is the general dilemma that I am facing. I'd be happy to speak with someone over the phone about this as well. Also, I haven't uploaded a file yet for confidentiality reasons. Thanks!
Solved by V. Q. in 12 mins