Hello,
I'm rather new with creating mail merge letters. Requesting some help on creating a mail merge letter for one-to-many relationships. Replaced names for privacy for the scenario:
Data Headers:
1. Shop Name
2. Related Shop Name (2nd store, but different shop name, but under same owner of "Shop Name")
3. Address
Data Content:
1. Shop Name: Famous Donuts
2. Related Shop Name: Ice Cream, Unicorns, Biscuits
3. Shop Name and Related Shop Name have different address locations
I want to create a mail merge that can send "Famous Donuts" one letter thanking them for the long-term business, but the letter includes all of the related shops (Ice Cream, Unicorns, and Biscuits) instead of sending three (3) letters for the 3 different shops to the same person. Is it possible to create this without any external add-ons which I've seen online? Thanks in advance!
I'm rather new with creating mail merge letters. Requesting some help on creating a mail merge letter for one-to-many relationships. Replaced names for privacy for the scenario:
Data Headers:
1. Shop Name
2. Related Shop Name (2nd store, but different shop name, but under same owner of "Shop Name")
3. Address
Data Content:
1. Shop Name: Famous Donuts
2. Related Shop Name: Ice Cream, Unicorns, Biscuits
3. Shop Name and Related Shop Name have different address locations
I want to create a mail merge that can send "Famous Donuts" one letter thanking them for the long-term business, but the letter includes all of the related shops (Ice Cream, Unicorns, and Biscuits) instead of sending three (3) letters for the 3 different shops to the same person. Is it possible to create this without any external add-ons which I've seen online? Thanks in advance!