Reply to thread

Message: [QUOTE="Peter Jamieson, post: 5507938"] I can export the database What type of database is it? (Excel workbook, access, some other database?) You may be able to do something directly in there. Otherwise, if a. you can get an export like this Product Quantity A 1 B 5 C 7 .. .. and you know the maximum Qty (let's say it is 10), then b. you can do this without having to resort to VBA:- 1. Create a directory (catalog) merge Put the following fields in it { IF { MERGEFIELD QUANTITY } > 0 "{ MERGEFIELD PRODUCT } " }{ IF { MERGEFIELD QUANTITY } > 1 "{ MERGEFIELD PRODUCT } " }{ IF { MERGEFIELD QUANTITY } > 2 "{ MERGEFIELD PRODUCT } " }{ IF { MERGEFIELD QUANTITY } > 3 "{ MERGEFIELD PRODUCT } " }{ IF { MERGEFIELD QUANTITY } > 4 "{ MERGEFIELD PRODUCT } " }{ IF { MERGEFIELD QUANTITY } > 5 "{ MERGEFIELD PRODUCT } " }{ IF { MERGEFIELD QUANTITY } > 6 "{ MERGEFIELD PRODUCT } " }{ IF { MERGEFIELD QUANTITY } > 7 "{ MERGEFIELD PRODUCT } " }{ IF { MERGEFIELD QUANTITY } > 8 "{ MERGEFIELD PRODUCT } " }{ IF { MERGEFIELD QUANTITY } > 9 "{ MERGEFIELD PRODUCT } " } NB, all the {} need to be the special field code braces you can enter using ctrl-F9 2. Merge to a new document. You should have one column containing the right number of rows for each PRODUCT. Manually insert the column header PRODUCT, save and close the document and use it as the data source for your label merge. Peter Jamieson [URL]http://tips.pjmsn.me.uk[/URL] [/QUOTE]