make a mailing list that sends only one piece of mail to each couple listed

I need to make a mailing list that sends only one piece of mail to each couple listed. I've already isolated those pairs of people that have the same address and last names. My list looks like this, one name per cell:
Sam Smith
Karen Smith
Alfonso Wilson
Judy Wilson
Alice White
Doug White

etc., etc...for thousands of names. Each pair has the same address a few cells over to the right.

What I want is to be able to do is merge a letter that's addressed to "The Smith Family" and salutation-ed "Dear Sam and Karen". I can do this if the list looks like this (I'll end up deleting the lines without first names):

Sam Smith Karen

Smith

Alfonso Wilson Judy

Wilson

Alice White Doug

White

I just need to move the one name up one row and to the right a few cells. Here's a macro I used last year to do this...it worked then, but I must have changed something...what gives? The macro only starts on the 10th row, names are printed all over the sheet....oy.

Please Login or Register  to view this content.

Hello ebaammo,

Welcome to the Forum! As a member, you now have full access to the knowledge and posting tools that make this site unique.

In order to provide you with prompt replies to your questions, there are a few rules we ask that you observe. Please remember to follow these rules when you post as a courtesy to your fellow members, and to those who are volunteering their time, and knowledge.

Readability is key in getting a fast response to your question. You have many tools available to assist you in formatting your post. Any code you post, whether a worksheet formula or VBA code should be wrapped. You can find a list of other HTML format options in the forum rules.

How to Wrap your Code
On the Message window Toolbar you will see the # icon. Select the text you want to appear in a Code Window, and Click the # icon. This will wrap the code for you. You can also do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the last line.

You can read the Forum rules by clicking on the link below.
Forum Rules
If you have any questions, contact me by clicking on my name Leith Ross

Sincerely,
Leith Ross