Hi, Ben... I tried creating my own page with the approach you described as my first attempt at printing labels... couldn't get the things to line up properly.
I finally went to Word to create the HTML for labels for me and decided to try to loop the entire page so as to not disrupt the alignment. I did get a solution worked up looping the entire 30-label page. I first setup a variable to control the row count used when the query loops the page: CFSET StartRow = 1 Then, I use CFOUTPUT Query= "Get_Addresses", Then just make each label like so (minus a lot of code): #Get_Addresses.First_Name[StartRow]#, etc. Second address uses: #Get_Addresses.First_Name[StartRow+1], etc. Then at the end of the 30-label page, I use: CFSET StartRow = StartRow + 30 and print labels 31 - 60. It's working fine so far... however, I'll probably go back at some point and see if I can get away with the method you described without breaking the printing alignment. Thanks for your response! Rick -----Original Message----- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Monday, December 11, 2006 9:00 AM To: CF-Talk Subject: RE: Printing Mailing Labels Advice Needed 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:263529 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4