Generating word letters that include a variable data table

Occasional Visitor

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 ProductProduct BrandStore NameAddressCityStateZip
MilkFarm FreshCVS550 Somewhere LaneNew YorkNY15121
WaterDasaniCVS550 Somewhere LaneNew YorkNY15121
ShampooHead and ShouldersCVS550 Somewhere LaneNew YorkNY15121
MilkFarm FreshRite Aid201 First StSan DiegoCA15222


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!

Related Conversations
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
Outlook, PowerPoint, Excel, Word Version 1.0?!
boossy in Discussions on
3 Replies