Rick, Don't wrap the output around 30 addresses. Just have a cfoutput loop with a single address inside. If you look at the HTML its probably just some table template. Then, just add the appropriate end row / start row if needed:
<table> <tr> <cfoutput query="qLabel"> <td>.....</td> <cfif (NOT (qLabel.CurrentRow MOD 3)) AND (qLabel.CurrentRow LT qLabel.RecordCount) > </tr><tr> </cfif> </cfoutput> </tr> </table> This way, your query will make much more sense. In this example, I am assuming there are 3 labels across (MOD 3). ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Friday, December 08, 2006 7:44 PM To: CF-Talk Subject: Printing Mailing Labels Advice Needed Hi, gang. I'm using MS Word to setup the HTML for printing mailing labels, then inserting a query into the HTML for getting my addresses. The addresses are 30 per page. I'm using "CFOUTPUT Query =" to output the info. In the HTML, I put the variables, #First_Name#, etc. Problem: The CFOUTPUT Query is wrapped around 30 labels at a time and I'm trying to figure out how to work the query or either the CFOUTPUT to output one address per label instead of one address on all 30 labels. I solved this before, but can't remember how I did it and now I can't find the code. Would something like using #get_addresses.first_name[1]# solve the problem? Other advice? Thanks, Rick PS - Remember CF 4.5 here. :o) (Still making money off that old software) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263516 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
