u/queenofmexicans

Hi all,

I'm looking for some guidance on using mail merge to print labels. I run a non-profit program that uses about 650 mailing labels each week. Most of these labels are single word (denoting a site location) but about 200 of these labels need both the site and a special diet. Currently the diets are all handwritten by a volunteer each week, but I believe this can be automated using the mail merge function (or something else? you tell me!)

Currently my order data is laid out like the image attached. I am able to get mail merge to print the labels by filtering for only the Special Diet bags. However, I am running into trouble when there is multiple of a Special Diet for the same Site, as noted by the number in column F "Special#"

As an example, in this photo, Site Cascade needs 3 Gluten Free labels. I can get mail merge to create 1 Cascade Gluten Free label, but is there a way for it to duplicate the labels based on the value in column F to return 3 Cascade Gluten Free labels?

I inherited this spreadsheet from a predecessor, so I am open to changing it. If there are ways to somehow create an array that takes the text value of column G and replicates it based on the value of column F, that could work too? Though I'm not sure how difficult it would be to retain the Site name in column A. Let me know what you think!

https://preview.redd.it/lljubdcelsxg1.jpg?width=595&format=pjpg&auto=webp&s=8566074da9c3477fd75e5a4428d942f4bc13a85d