The formula will work and not fill the resulting page of labels as long as it returns the "" in the last case. I seem to have found some more information that may be useful in helping me figure this out. it's not like it's recognizing an infinite number of rows in the CSV file, therefore it can't be an issue with the CSV has to be the Mail Merge word document)
![how to mail merge labels from excel to word youtube how to mail merge labels from excel to word youtube](https://i.ytimg.com/vi/HKU-txPKcmA/maxresdefault.jpg)
Some important notes that might be helpful:ġ) The formula result for the last label only persists through the rest of the labels on that page (i.e. The other 15 labels should be completely empty/blank, but instead, they show the $1.69 price! They show none of the other data fields except for the IF formula's result of the very last label. The last item (label) has a RETAIL of $1.69 (directly from the CSV file). For example, I have 3 labels that all have multiple lines of data on them (item #, receipt alias, size, and retail or promo price). The first 3 labels show the correct data (PROMO PRICE if there is one, else RETAIL), BUT the rest of the labels should be blank.instead, they are showing the last printed price (regardless of whether it is a PROMO PRICE or a RETAIL. The rest of the rows are blank (verified by selecting like 200 rows and deleting just to be safe). So, here is the problem I'm having: Let's say I only have 3 rows of data in the CSV file (3 items that need labels). The actual word document (mail merge file) is formatted to return 18 labels per page (3 rows of 6) and works from the top right corner down, then middle top down, then left top down.
![how to mail merge labels from excel to word youtube how to mail merge labels from excel to word youtube](https://i.ytimg.com/vi/jNEyvGHvlpk/mqdefault.jpg)
Now, this works well and returns the data that I need. I have that much worked out using an IF formula in word which is:
![how to mail merge labels from excel to word youtube how to mail merge labels from excel to word youtube](http://zelda23publishing.com/tutorials/wordimages/67577.jpg)
If the PROMO PRICE column is blank (empty), it should show the RETAIL. The fields are as follows:īasically, part of the label to show the a certain price. All cells within the range are formatted as straight text. Basically, we have a excel CSV file that holds text. Ok, so we have a process that we use to create shelf labels at a store.