![]() ![]() 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#. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |