Generating word letters that include a variable data table

[XDark_FenixX]

Hi all,

I'm looking to create a Macro that would generate word letters but I need to include a table at the end.  I've seen mail merge and similar examples that essentially do a find/replace of key words, but I want to ensure that one recipient gets all affected line items in one letter. 

As an example, lets use the table below:

Affected Product	Product Brand	Store Name	Address	City	State	Zip
Milk	Farm Fresh	CVS	550 Somewhere Lane	New York	NY	15121
Water	Dasani	CVS	550 Somewhere Lane	New York	NY	15121
Shampoo	Head and Shoulders	CVS	550 Somewhere Lane	New York	NY	15121
Milk	Farm Fresh	Rite Aid	201 First St	San Diego	CA	15222

Lets say we are sending recall letters to the above stores but want the letter to list all affected products and their associated brand in a table.  IE CVS would get 1 letter with a table of 3 items and Rite Aid would get a letter with 1.  How would I go about doing this? 

Thank you in advance!