When converting a Word document from an Excel data source to mailing labels, you must re-name your Excel file to the document name and the appendage '.xls' and NOT.xlsx!! This took me a frustrating afternoon to figure out that on a Macintosh Powerbook G4 run on Mac OS X 10.4.11 my Excel workbook will not convert to labels readily unless I renamed the extension.xls. After this, when I opened the Word and Mail Merge and go to Open Data Source, it will read with the.xls! My Word is Microsoft Word 2008 for Mac version 12.2.3.

Printing mail labels with Excel lets you avoid addressing envelopes by hand. Use Microsoft Word to prepare the document by removing section breaks between labels, deleting empty placeholders.

• Create a blank new document. • Insert a picture, graphic, clipart, etc. That you want to use on your label.

Be sure to make it small enough to fit on the label (you may have to guess at first.) • IMPORTANT:Click on the graphic BEFORE you start the mailing label process. • Click on the Mailingstab • In the Creategroup, click on Labels. Metro last light guide. • In the Envelopes and Labelsdialog box, use the.  Convert pdf files to word for mac free online. button to select the type of labels you will be using (for example Avery 5261).

• Click the New Documentbutton Note: this will create a new page of labels with the graphic on each label. • Type in the address for each label note: the labels are set up as a MS Word table.