Consecutive numbers on labels Excel Word Merge Mac

Question

Hi, I want to make consecutive numbers to print on my 7x3cm labels. I have merged a Excel sheet with the numbers into word, but when I make the label up it shows two labels and prints the numbers on every second label. I can't figure out what I'm doing wrong here or how to change it.

Answer 1

Without seeing your Excel sheet, knowing the style number & brand of label, as well as the specific steps you're taking it's rather difficult to determine. All I can offer is the appropriate procedure.

The list in Excel should have a Field Name at the top with no blank cells in the list, such as:

In Word go to the Mailings tab, then;

1. Click the Start Mail Merge tool & select Labels
2. Choose the appropriate label Product Number, OK
3. Click Select Recipients> Existing List then pick your Excel file
   1. Click Yes
   2. Click OK
4. Open the Insert Merge Field list to insert the field name on the first label
5. Click the Update Labels tool
6. Finish & Merge as you wish

See macOS page of this Word Help article on Mail Merge to Labels for more info.

Answer 2

Hi, Thank you for your reply. I have done the Excel Sheet exactly like you have said. And everything seems to merge but the problem I am having is trying to print a Custom Label as the labels that are there to choose from aren't the right size or Brand. So I have created a Custom Label, but once I create it, it then gives me two labels instead of one. When I preview it and print them out the numbers are on every second label. I am not going to buy other labels as I bought 2 rolls of 1000 so I want to use these labels. Hope that's a better explanation.

Answer 3

What is the brand & product number of the labels?

Answer 4

They are a generic thermal label from Inkstation.  CGW4227 70mm X 30mm Perforated Direct Thermal Labels

Answer 5

After adding the mergefield for the first label, did you click on 'update labels' before running the merge?