Mac word mail merge tutorial

Primary Sidebar
Contents:
  1. How to Create a Mail Merge in Word 2011 for Mac
  2. To access Lynda.com courses again, please join LinkedIn Learning
  3. Inserting Merge Fields into Word (Mac)
  4. Use mail merge for bulk email, letters, labels, and envelopes - Office Support

Create and send email messages. Envelopes or Labels where names and addresses come from your data source. Create and print a batch of envelopes for mailing.

Create and print sheets of mailing labels. Directory that lists a batch of information for each item in your data source. Use it to print out your contact list, or to list groups of information, like all of the students in each class. This type of document is also called a catalog merge.

How to Create a Mail Merge in Word 2011 for Mac

Create a directory of names, addresses, and other information. Excel spreadsheets and Outlook contact lists are the most common data sources, but if you don't yet have a data source, you can type it up in Word, as part of the mail merge process. Excel spreadsheet works well as a data source if all data is on one sheet and the data is formatted so that it can be read by Word. For more info, see Prepare your data source in Excel for a mail merge in Word for Mac. Outlook Contact List contains data in a format that can be read by Word.

See Use Outlook contacts as a data source for a mail merge. Word data file is a data source you can create on the fly, within Word.

Step 1: Create your data list

For more info, see Set up a mail merge list with Word. Create envelopes by using mail merge in Word. Create and print labels using mail merge. For more info, see Prepare your data source in Excel for a mail merge in Word. Create mailing labels in Word by using mail merge.

To access Lynda.com courses again, please join LinkedIn Learning

If you have the Word desktop application, open the document there and perform a mail merge there. Data sources Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel or Outlook If you know you'll be using Excel or Outlook as the source of your data, see: Mail merge using an Excel spreadsheet Use Outlook contacts as a data source for a mail merge Document types Word provides tools for incorporating your data into the following kinds of documents.

Follow the links for details about each type: Letters that include a personalized greeting. Create and send email messages Envelopes or Labels where names and addresses come from your data source. Create and print a batch of envelopes for mailing Create and print sheets of mailing labels Directory that lists a batch of information for each item in your data source. See Use Outlook contacts as a data source for a mail merge Word data file is a data source you can create on the fly, within Word.

Document types Letters that include a personalized greeting.

Create envelopes by using mail merge in Word Create and print labels using mail merge. Document types Word provides tools for incorporating your data into the following kinds of documents.

Next to 3 in the app, choose the file format you would like the mail merge to use for each envelope. In this example, we will select Pages Document. Other options you could select are:. Next to 4 in the app, click Choose Export Folder and select the location where you want the merged files to be saved. Number 5 in the app is an optional function that can be used to automatically send individual emails related to the mail merge.

How to do a Mail Merge in Microsoft® Word for Mac® 2011

We won't be using it in this example. Now that you have assigned placeholder tags from the Pages document to all of the data items imported from the Numbers data file, you're ready to run the mail merge. Next to 6 in the app, click Begin to start the mail merge. You will be prompted to confirm that you want to perform a data merge using the front Pages document. Click Begin. The mail merge AppleScript you've designed with the app will then run. A Pages document will be created for each person in the spreadsheet and be populated with their names and addresses.

Inserting Merge Fields into Word (Mac)

You'll see each of these pop open and the data added before the script moves on to the next one. Each file will be named after the envelope template with a number appended after a dash. When the script is completed, a completion dialog box will appear. If you click Show, you will be taken to the folder you picked to save the individual files. Share Pin Email.

Use mail merge for bulk email, letters, labels, and envelopes - Office Support

Updated January 12, Click Format in the upper right of the Pages window to open the formatting menu on the right side. Then, click the More tab. In the formatting menu at the bottom, under Script Tag, type in a name for this placeholder text field. Next to 1 in the app, click the dropdown menu and choose Selection of Numbers Table. Click Import. The first row will be pulled in and displayed.