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. 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: 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |