Topics Map > Microsoft Office 365
Office 365 (Outlook 2013) - Set up a Mail Merge List with Outlook Contacts
1. In Word, Click Mailings > Start Mail Merge, and then click the kind of mail merge you want to run.
2. Click Select Recipients > Choose from Outlook Contacts.
If you have more than one contacts list or profile in Outlook, it might prompt you to choose the list or profile you want to use for the merge.
3. Now your Outlook contacts are connected to your mail merge document.
4. Select the names (or rows) you want to include by checking the check box for each row. If you want to see a specific subset of your list, you can filter and sort the list to get the view you want.
5. Click OK, and you’re ready to insert merge fields.
Word includes the Greeting Line and Address Block fields, which add all the fields for a greeting or address, so you don’t have to add each field one at a time.
For example, to add a standard greeting to your email message or letter, use the Greeting Line merge field.
1. Click where you want to add the greeting.
2. Click Greeting Line.
Note: If the Greeting Line command is grayed out, click Select Recipients and choose the kind of mailing list you’re using—Outlook Contacts, an Excel spreadsheet, or an .mdb file that you created earlier in Word. If you don’t have a mailing list yet, click Type New List to create your list in Word.
3. Choose the name style that you want to use, and set other options.
Tip: To be sure Word finds the names and addresses in your list, click Match Fields. Check that the fields you want appear in the list. If a field you want says Not Matched, click the drop-down list for that field and then click the column name that matches that column in your list.
4. To make sure the field is formatted the way you want, highlight the whole field, including the marks at each end.
5. Click Home, and then check the font and font size.
6. Click Line Spacing to make sure the line spacing matches the spacing in the rest of your document.
7. After you add the fields you want to merge, type the information you want to be the same in each email message you send during the merge.
These same steps work for adding addresses to a mailing labels document—all at once, instead of separately inserting the name, street, city, and all the other parts of the address.
Just click Address Block instead of Greeting Line.
Note If the Address Block command is grayed out, click Select Recipients and choose the kind of mailing list you’re using—Outlook Contacts, an Excel spreadsheet, or an .mdb file that you created earlier in Word. If you don’t have a mailing list yet, click Type New List to create your list in Word.
Word gives you options for making the name on the address more formal or more informal.
Tip: To make mailing labels single spaced, select the Address Block field, click Page Layout and enter 0 in the Before and After boxes under Spacing.
If you want to add a customized greeting or other information from your mailing list, you can add fields one a time.
1. Click in your document where you want to add the mail merge field.
2. Click the arrow next to Insert Merge Field, and then click the field name.
3. If you don’t see your field name in the list, click the Insert Merge Field button.
4. Click Database Fields to see the list of fields that are in your data source.
5. Click the field you want to add.
6. Click Insert.
To control how Word merges information, you can use advance fields to set up rules. For example, you can use the Skip Record If field to skip blank lines in your data source. Or you can use the Next Record field to merge information from two items into the same document. Word automatically adds the Next Record field when you set up a label merge.
To set up a rule and an advanced field, click Mailings > Rules and click the field you want to add.