General discussion

Locked

automatic number for labels

By Eminent87 ·
Hi,

We have to print out labels in avery format with just our clients number on it. For example, Client001, Client002, etc... is it possible to create automatic label in word or excel where it can automatically generate the last couple digits automatically, just like Client####? And then just print them out as labels. Thanks.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

automatic number for labels

by DKlippert In reply to automatic number for labe ...

Sequentially numbering multiple copies of single document using a macro

http://tinyurl.com/72uf


or:

1. Create one page of labels as a mail merge main document.

2. Create a data source in Excel, using AutoFill to drag and fill cells with
as many client numbers as you need.If you start with Client0001, Excel will fill the series.

3. Insert the client number as a merge field referring to the Excel data.

4. Run the merge to new document

Collapse -

automatic number for labels

by Eminent87 In reply to automatic number for labe ...

That worked, thanks!

Collapse -

automatic number for labels

by kees.valkenswaard In reply to automatic number for labe ...

The mail merge method is the one I normally use. Even if you would require the same number a multiple amount of times this method will work, as long as the amount of labels on one or more master pages is a multiple of the numbers required for one client.
Just remove the next record field from those fields where you want the same number.
By using the tab option in tables it is very easy to jump to the next field and copy the information into a subsequent cell.
Suppose you have 24 labels on a sheet and need three copies for each client you should only have next record fields in the left most cell of rows 2 to 8 [assuming a 3 x 8 sheet]
It is better to use a column heading in Excel which allows easy referencing in Word.
Good luck.

Collapse -

automatic number for labels

by Eminent87 In reply to automatic number for labe ...

Poster rated this answer

Collapse -

automatic number for labels

by Eminent87 In reply to automatic number for labe ...

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums