On the Labels tab, under Format, define the label format. You can design both labels and business cards through the Labels dialog.Ĭhoose File - New - Labels to open the Labels dialog. Click Print to print the labels.You are set, your labels should print shortly.Creating and Printing Labels and Business Cardsĭesigning Business Cards Through a DialogĬhoose File - New - Business Cards to open the Business Cards dialog, which allows you to choose how your business cards will look. You can save the document should you wish to print the same labels in the future. If you have any comments or questions please use the comments form below. Click on the View Merged Data button in the Preview Results section to see what your labels will look like. Take this opportunity to format the labels with the standard formatting tools. You can change font size, color, alignment, and more. You can navigate through all of your labels by using the Next Record and Previous Record buttons.Note: You may want to preview all of your records to ensure that a name doesn’t stick out or overflow in one of your labels.10. When you are ready to print, click on the Merge to Printer button.11. Use the Insert Merge Field drop-down to select the fields you wish to include in the label. In my case the spreadsheet had columns (fields) for Name, Address, City, State, and Zip Code. Choose each of the fields to add them in the order you wish to appear. You should also take this opportunity to place spaces and commas to divide the information.Notice that I placed the Name, Address, and City/State/Zip fields in separate lines and that I added a space and comma between City and State. Make sure to select the company and label number.3. Verify that the label dimensions are correct and click OK.Now that we have the correct label selected we will need to select the data source for the names and addresses that will be printed on the labels, expand the Select Recipients List section in the Mail Merge Manager to continue.4. Click Get List and select Open Data Source from the list.Note: This is where you can choose a FileMaker database, Apple Address book, or Office Address book as a data source.5. When the dialog box opens select the pre-formatted Excel spreadsheet containing the address list and click Open.6. You will see the following prompt, click OK to continue.7. Select the sheet that contains the address list data from the Excel workbook. #Make Mailing Labels From Outlook Contacts Zip Code In#.

How to make mailing labels on mac