MS Publisher - Auto Incremental Numbers

Hello ppl,
I want to print avery label 7160. I have already designed and its ready to print. I have to print on each label numbers starting from 1 to 200. I tried to write macro but not sure how to tell it to print on the label. Your help would be much appreciated.
Thanks in advance.
LVL 6
masirofAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

aflockhartCommented:
From the Help:

"The pre-designed label publications in Publisher are set up to print a whole sheet of identical labels. That means that if you open a pre-designed label publication and type the content for a single label, when you print, that label content appears on every single label on your label sheet. "



You might want to experiment with the Mail merge feature in Publisher - you would need to set up an external data source that contained the list of numbers - you could do this in Excel.


Otherwise you should be able to do this using Word mail merge, and inserting the record numbers in the same way.
0
masirofAuthor Commented:
Can you guide me detailed please. No matter with what, I want to print with incrementing numbers..
0
aflockhartCommented:
What software and versions do you have ?
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

masirofAuthor Commented:
MS Office 2003 FULL
0
masirofAuthor Commented:
I cant get it done, please help :))

ignore the link buddy,
http://www.experts-exchange.com/Web/Web_Languages/ASP/Q_21078295.html
0
masirofAuthor Commented:
0
aflockhartCommented:
Assuming you want the numbers to be the only changing text on the labels:

Set up an Excel sheet which contains one column, with column heading MyNumber. Under this heading, put your numbers 1 to 200  (Type 1 into the first cell, then hold down the control key while you drag the black dot (fill handle) down.  Save this document.

In WORD, create a new doc.  
Use Tools, Letters and mailings, Mail Merge. THis opens a Mail merge helper
Step 1 Choose LABELS, then Next
Step 2 select Label Options to choose Label size.  L7160 is in the Avery A4 and A5 group
Step 3 Select recipients - choose "Use an existing list", and use Browse to choose your excel sheet. Select the sheet that contains your data.  Click Next
Step 4 Arrange your labels: Go to the first label; click the "More items" entry, then selectg "MyNumber" as the item you want to insert.  (YOu can also add any fixed text at this stage. ) Then click the "UPdate all labels" button.  Click Next
Step 5: Preview your labels
Step 6: complete the merge


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
masirofAuthor Commented:
Sorry for delay, I will try it today and get back.
0
masirofAuthor Commented:
Thanks, I did it with Publisher. The same way :)
Thank you and again sorry for the delay.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.