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.
|