I have an excel spreadsheet with customer information, I am trying to create a mail merge to link to word that will show 1 customer to many orders.
Ex.
Jane doe 1 Book
Jane doe 1 Folder
John doe 2 Folders
Jenny doe 3 Candles
Jenny doe 5 Folders
I want the letter in word to appear like
jane doe
1 Book
1 Folder
_________________________
John doe
2 folders
________________________
Jenny doe
3 candles
5 folders
Each on a separate page.
Any help would be appreciated. Thanks
Ex.
Jane doe 1 Book
Jane doe 1 Folder
John doe 2 Folders
Jenny doe 3 Candles
Jenny doe 5 Folders
I want the letter in word to appear like
jane doe
1 Book
1 Folder
_________________________
John doe
2 folders
________________________
Jenny doe
3 candles
5 folders
Each on a separate page.
Any help would be appreciated. Thanks