Hi, I am in the process of creating 500 labels for Company Christmas cards. I followed all of the steps and I was able to create the labels.BUT for some strange reason when I go to look at each page to make sure they merged correctly, I see that the contact information is repeating itself on the next page before it adds a new contact. I can NOT figure out what it is I'm doing wrong.

Head over to the Mailings tab > Start Mail Merge group and click Step by Step Mail Merge Wizard. The Mail Merge pane will open in the right part of the screen. Select Labels and click the Next: Starting document link near the bottom of the Mail Merge pane.

I'm using the Avery Template 5162. Its a 14up label.

I have like 467 contacts. So this should average out to 33 sheets of labels. Well, when I click the pages to preview the labels its a total of 445 pages. That's incorrect. Can you please help me?

Thank you, Shana.

I am using Mac OS X 10.8.3. I downloaded Word and Excel for Mac Version 14.2.0. I am trying to use the mail merge feature and every time I choose my Excel spreadsheet (in.xlsx format )as my 'open data source' a pop up window tells me it has to be converted.

In choosing every option given to convert, it tells me the file cannot be read. I tried saving my Excel spreadsheet in.xls format and it still doesn't work. I am sure my Excel spreadsheet is formatted correctly. Is it just not possible with this version of Word and Excel or is my OS dated???? This is driving me crazy.