I think you might have given me the solution but I don't have my data file
with me to test the Mail Merge Format Key Field option. I will reply back if
it works for my needs. Thank you so much for what looks like my solution.



"Exhausted..." wrote:

I'm not sure if this is an Excel or Word problem. I have an exported file
from a database which has multiple lines that need to be merged into a form
letter. The problem is I there could be up to anywhere from 1- 6 lines for
per person but I need the data from the 1-6 lines merged to the form letter.
The worksheet looks somewhat like this with the first line being the headers:

ID FN LN Line CFN CLN ADDRESS HOME#
WORK#
123123 Joe Smith 1 Pamela Smith xxxxxxxxx 303-1111
750-4561
123123 Joe Smith 2 Barkley Jones xxxxxxxxx 720-4591
456-7897
123123 Joe Smith 3 Jackie Smith xxxxxxxxx 303-1245
303-4246
123123 Joe Smith Cindy Smith xxxxxxxxx 303-1245
303-4579

I want to merge the data for Joe Smith into a form letter as follows:

123123 Joe Smith
CFN Pamela Smith 1
CFN Barkley Jones 2
CFN Jackie Smith 3
CFN Cindy Smith

I know I can physically manipulate the spreadsheet and move the data onto
one row form Joe Smith with different headers but there are about 150
spreadsheets and they range from 500- 6000 lines. Is there a formula that
will automatically pick up and link the data from the ID column which is the
only column that is unique?

Exhausted...