Help: Creating complex shipping labels

S

StevenL

Can someone help answer these 2 questions on creating labels

1. How to link information from a cell in excel to multiple labels in word
label template. ie) cell A2 = "50" and "50" be reflected on the label

2. Can a formula be written so that ea label also indicates which of the 50
it is.
ie) label 1 = "1 of 50", label 2 = "2 of 50", etc...

3. Can the number keyed in to cell A2 dictate the number of labels to create.
ie) cell a2 = "50" and so "50" is reflected on 50 labels,
10 labels per page so 5 pages automatically fill in same as the 1st label.

Thank you in advance for any assistance
StevenL
 
S

SteveT

Thank you Beth,

I'm assuming you are addressing question # 3?
This can be solved by the user only printing correct number of pages.
(VBA code must be pretty complicated)

What about 1 & 2, is there a simple solution? Considered Space special
option and a formula within word form field in Word but didn't know if an
easier route.

Again, thanks for your response.
 
B

Beth Melton

If you are using a mail merge then item 2 could be something along the
lines of using the MERGEREC field along with a reference to A2.

But for item 3, if you want to create the number of labels dictated by
cell A2 then you would need to use VBA to create x number of labels -
especially if you are working with a single record.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
Top