Microsoft Office 2016 Mac Mail Merge

Apr 17, 2018  If you use Microsoft Office 2016 with a Mac computer, you can easily import addresses or other data from an Excel spreadsheet or from your Apple Contacts. If the text doesn't fit, press Ctrl + A to select all, right-click and select Paragraph, select the Don't add space between paragraphs of the same style box, and click OK. Click Next: Complete the merge. Click Print, click OK, and click OK again. Nov 29, 2016 How to use http endpoint for mail merge data (Office for MAC). For-mac Question 3 11/9/2016 2:43:24 PM 1:25:00 AM Welcome to the Microsoft Office for IT.

  1. Mail Merge Outlook 2016
  2. Microsoft 2016 Mail Merge Directions

After you choose the main document type in Microsoft Office, you next choose the data list. A data list must be in a structured format, such as a Word document containing a table, an Excel workbook, or a database such as the Contacts list in Outlook.

MailMail

If you plan on using an existing Word or Excel file, it’s important to set it up beforehand. You might need to open that file separately to prepare it.

If it’s a Word table, keep these points in mind:

  • Make sure that there is nothing above the table in the document file.

  • The first row of the table must contain the field names (column labels).

  • All the rest of the rows must contain the data records.

    A Word table suitable for use as a mail merge data list.

If it’s an Excel worksheet, keep these points in mind:

Mail Merge Outlook 2016

  • Row 1 must contain the field names (column labels).

  • All contiguous rows below row 1contain the data records.

    An Excel worksheet suitable for use as a mail merge data list.

When your data source file is ready, follow these steps to connect it to your main document in Word:

  1. With the main document open, on the Mailings tab, click Select Recipients.

  2. Click Use an Existing List.

  3. Navigate to the location containing your data file and select it.

  4. Click Open.

Microsoft 2016 Mail Merge Directions

Congratulations, your data file is now attached. You won’t notice anything different yet, though, because you must insert merge fields.