Reply
 
Thread Tools Display Modes
  #1   Report Post  
dansmith dansmith is offline
Junior Member
 
Posts: 1
Default Variable label counts

If I have seen multiple permutations of this question around the web, but there seems to be no answer to it. I am creating a set of inventory labels. One of the fields in Excel is quantity. Most items are a single unit. However, others may have ten in stock. Is there anyway to force mail merge to repeat the label x number of times before going to next record?
  #2   Report Post  
Big_Al Big_Al is offline
Junior Member
 
Location: Bristol UK
Posts: 22
Default

This seems to be the easiest way (non VBA) https://groups.google.com/group/micr...le+times&hl=en
However, i think there's a limit on the number of If's you can use (probably 19) so this wouldn't work if you have more than 19 in your quantity column...

Alternatively, the consensus is to create a new sheet specifically for the merge. Have a look at http://www.excelforum.com/excel-gene...f-records.html

Hope this helps a little
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing Variable Label Quantities from a Merge Wake Manor Microsoft Word Help 16 February 22nd 10 08:22 AM
Printing Variable Label Quantities from a Merge Wake Manor Microsoft Word Help 0 February 19th 10 10:53 PM
Virtual line counts versus physical line counts LindaP Microsoft Word Help 1 November 19th 09 06:47 AM
run time error 91 object variable or with block variable not set GJ Microsoft Word Help 0 August 5th 05 02:43 PM
run time error 91 Object Variable or With Block Variable not set champcf Microsoft Word Help 3 January 6th 05 01:17 PM


All times are GMT +1. The time now is 05:09 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"