View Single Post
 
Old 11-25-2021, 04:00 PM
Pumpkin9 Pumpkin9 is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2021
Posts: 2
Pumpkin9 is on a distinguished road
Default Group multiple rows from Excel to Word - Mail Merge

Hi,

I have an excel file which contains data about customers and their purchase products. Each customer has their own ID and this is my starting point. Since one customer has more products, I need to specify the products into one page when doing mail merge, instead of creating multiple pages per customer. The text would look like this (just as an example):

Dear ----,

Thank you for your purchase.

Please find below all the products that you have purchased from us:

------------

I would really appreciate your help on this, as I need to figure it out as soon as possible. I tried the tutorials provided in some previous threads, but i have no knowledge in coding, so if you have anything that explains the process with baby steps I will highly appreciate it.
I use Word 365 and I think this additionally makes it harder to figure out the mail merge.
Reply With Quote