Mail Merge for Customers with Multiple Rows of Data

[rosevilleca]

Need Help!

Have a datasheet with 4500+ rows of data (stores) for 1800 customers (owners). Need to mail merge into a single document for each of the 1800 customers. Within the document to the owner, there needs to be a listing that will reflect data for each of the separate stores that is now in column (multiple) form. On the last page of the document, there will be a list that will reflect STORE ADDRESS for each of the stores along with other information specific to that store.

How can I create a document that will incorporate this? See example below.

[TABLE="width: 775"]
<TBODY>[TR]
[TD]CUSTOMER</SPAN>[/TD]
[TD]STORE ID</SPAN>[/TD]
[TD]STORE NAME</SPAN>[/TD]
[TD]STORE ADDRESS</SPAN>[/TD]
[/TR]
[TR]
[TD]112</SPAN>[/TD]
[TD]317752</SPAN>[/TD]
[TD]JOHN'S MARKET 1</SPAN>[/TD]
[TD]123 MAIN STREET ORLANDO, FL 32121</SPAN>[/TD]
[/TR]
[TR]
[TD]112</SPAN>[/TD]
[TD]319818</SPAN>[/TD]
[TD]JOHN'S MARKET 2</SPAN>[/TD]
[TD]1243 ELM STREET ORLANDO, FL 31248</SPAN>[/TD]
[/TR]
[TR]
[TD]112</SPAN>[/TD]
[TD]320228</SPAN>[/TD]
[TD]JOHN'S MARKET 3</SPAN>[/TD]
[TD]3215 SPRUCE ORLANDO FL, 31545</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL></COLGROUP>[/TABLE]