• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 893
  • Last Modified:

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.
0
masirof
Asked:
masirof
  • 6
  • 3
1 Solution
 
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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
 
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

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now