View Single Post
 
Old 04-24-2023, 01:43 PM
Jbro00 Jbro00 is offline Windows 11 Office 2021
Novice
 
Join Date: Apr 2023
Posts: 3
Jbro00 is on a distinguished road
Default How to get different labels depending on data?

Hopefully I haven't overlooked something simple here...
I need mail merge to create labels, the information will be pulled from an excel sheet.
Say I'm selling food, I have the customers information and all the different food items they have ordered.
I would like the labels to be
Customer info, food order, food order, food order, next customer info, food order, etc...

My data sheet is basically set up as following
Customer info - item ordered - quantity

If a customer ordered 1 beef burrito, and 2 checken burritos how would I go about making mail merge print,
Customer info, beef burrito, chicken burrito, chicken burrito?

I may not even be in the right ball park here but any advice or guidance is greatly appreciated.
Reply With Quote