MAIL MERGE OUTLOOK 2011 HOW TO PRINT LABELS

Mail Merge Outlook 2011 How To Print Labels

For those of your coming from Office for Windows you will notice that there a lot of differences between Mail Merge in Windows and Mac, but IвЂ™ve detailed each of the steps below to guide through the entire process. In the steps below I will show you how to print labels from a list using Word 2011. In this screencast, David Wicks, director of Instructional Technology at Seattle Pacific University, shares how to create a Smart Folder to manage unread ema.Are you trying to print a set of labels from an address list stored in Excel, FileMaker, or your Apple Contact list? If so you are going to love this guide. Office 365 consumer subscribers can get the new Outlook for Mac by going. Office 365 Commercial customers can get the new Outlook for Mac by accessing their Office 365 Portal, (Gear icon > Office 365 Settings > Software > Outlook for Mac icon) or visiting the Software page. Mac OS X 10.9.3 and above.

Software/Hardware used: Excel 2011 and Word 2011 running on Mac OS X.Before proceeding the first thing you need to do is ensure that you have a properly formatted Excel spreadsheet to use as the data source for your labels. Mail merge is not just for documents you can use it for brochures, newsletters, or materials for mass mailings. When the user used mail merge to outlook with all records and using html, it showed mail merge finished.Using the Mail Merge Feature in Microsoft Word 2016 for Mac. Data source is a testing excel file with colume A: name and colume B: emailaddress. Outlook is using imap gmail. Then I help her to change to use Oultook email and set default email program to Outlook.

In the Mail Merge Manager window click on Select Document Type to expand the selection. In this case we will be printing labels, but you can also print form letters, envelopes, and catalog.1. Click Mail Merge Manager from the list.First thing we need to do is select the document type that you will be printing. Create a blank document in Word 2011 and click Tools.2.

When the dialog box opens select the pre-formatted Excel spreadsheet containing the address list and click Open.6. 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. 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. Make sure to select the company and label number.3. Select the Label product company from the list, in this example I used Avery label number 5161.

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. You can change font size, color, alignment, and more. Take this opportunity to format the labels with the standard formatting tools. Click on the View Merged Data button in the Preview Results section to see what your labels will look like. Formatting is up to you, but this will ensure that when the data is pulled it isnвЂ™t bunched up together.If you click OK and wish to edit the data fields use the placeholders in the Insert Placeholder section to drag fields to the label sheet.WeвЂ™re almost ready to print, but before we do that letвЂ™s see what the labels will look like.9. 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.

If you have any comments or questions please use the comments form below. You can save the document should you wish to print the same labels in the future. Click Print to print the labels.You are set, your labels should print shortly. When the Print window appears, select the appropriate settings for the print quality and paper size.

Mail Merge Outlook For Mac 2011