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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies