Word for mac mail merge

Choose OK to add the new label to the Product number list. Choose OK to close the Layout Options box. Your document now displays a table with an outline of the labels the dimension and shape of the labels depends on the label product you chose. If you do not see the table, on the Table Layout tab, choose View Gridlines. On the File menu, choose Save to save your document.

On the Mailings tab, choose Select Recipients , and then choose an option. In the Edit List Fields dialog box, Word automatically creates fields for some basic information, such as first name, last name, and address. If you want to add a new field—for example, a message field—add it now, so you can fill it in when you type the entries. To change the order of the fields, click the field you want to move, and then click the up or down arrows to move the field where you want it. When all of the fields are set up the way you want them, click Create to create the list. In the Open Workbook dialog box, select the sheet you want to use, and leave Cell Range blank to use the entire worksheet or enter a cell range for the data you want to use, and then choose OK.

How to Do a Mail Merge & Labels Using Word 2011 on mac computer

Choose Filter Recipients to select the recipients you want to include. For Outlook contacts, in the Query Options dialog box, next to List mail merge recipients by , select Complete record. In the list of contacts, select the contacts you want to include in the mail merge, and then choose OK.

For Apple contacts, in the Query Options dialog box, under Apple Group Contacts , choose the group you want to include in the mail merge, and then choose OK.

What bulk mailing documents do you want to create?

On the Mailings tab, choose Insert Merge Field and select the field you want to show on your labels. Continue adding fields until you've added all the information you want on the labels, and then choose OK. On the Mailings tab, choose Update Labels to add the fields to all of the labels. Format the fields in the first label so it looks the way you want the rest of your labels to look. For example, include a space between First and Last name fields and press Return to start a new line for the Address field. On the Mailings tab, choose Update Labels to apply the formatting to all of your labels.

On the Mailings tab, choose Preview Results to see how the labels will look. Choose Preview Results again to view, add or remove merge fields. To make additional formatting changes, format the first label, and then, on the Mailings tab, choose Update labels. Create and print a single label in Word.

Thank you for your feedback!

Create and print a single envelope in Word for Mac. Create a data source for a mail merge. When you perform a mail merge, Word inserts the records from a data source, or recipients list, into your main document. A recipients list for a mail merge operation can be an Excel sheet, the Office Address Book, a FileMaker Pro database, a Word document, or a delimited text file. You must have an existing recipients list, such as a Word document that has addresses, to complete this procedure.


  • Mail Merge Options - OS X.
  • make mac run like pc.
  • mac os x 10.5 leopard retail install dvd.
  • Create envelopes by using mail merge in Word for Mac.
  • Office 2011 for Mac All-in-One For Dummies?
  • Data sources for mail merge!

For more information about how to set up a recipients list, see Create a data source for a mail merge. On the File menu, choose New Blank Document.

Create a data source for a mail merge

On the Tools menu, choose Mail Merge Manager. Under 1. Under Printer information , choose the type of printer that you use. On the Label products pop-up menu, click the manufacturer of your labels. For more label products, on the Label products pop-up menu, choose Other.


  1. Create mailing labels in Word by using mail merge - Word for Mac.
  2. best game emulators for mac;
  3. Mail merge in Word for Mac - Word for Mac.
  4. free windows media player download for mac os x.
  5. Mail merge in Word for Mac.
  6. mac demarco chamber of reflection piano.
  7. Under Product number , select the type of label that you have, and then choose OK. For information about the margins and other characteristics of a label, choose Details. In the Mail Merge Manager , under 2. To return to this dialog box later, in the Mail Merge Manager under 2.

    Select Recipients List , choose Add or remove placeholders on labels. You can export Apple contacts into an Excel spreadsheet and use it as your mailing list for mail merge. You can use any text file that has data fields separated or delimited by tab characters or commas and data records separated by paragraph marks. On the Standard toolbar, choose New. On the Tools menu, choose Mail Merge Manager. Under 1. Under 2. In the Field names in header row box, click any field names that you don't want to include in your data source, choose Remove Field Name , and then select OK.

    Type a name and choose a location for your data source, and then choose Save. In the Data Form dialog box, type the data for one data record for example, a recipient's first name in FirstName , last name in LastName , street address in Address1 , and so on. Do not enter spaces in boxes that you want to leave blank. After you finish filling in the boxes for one record, choose Add New.

    Mail Merges on Mac

    The first row of cells, called the header record, contains the data field names. Each subsequent row contains one record, such as the name and address of a person. Later, as you create the labels, you use the fields in the header record to specify what data goes where. For example, in the first column of the first row, type Name ; in the second column, type Address ; in the third column, type City ; in the forth column, type State ; and then in the fifth column, type Postal Code , so that your Excel sheet looks something like this:.

    Add as many additional rows of addresses as you want. Your Excel sheet should now look something like this:. Choose Save. If you do not close the Excel workbook that contains your list, or if you reopen it before you finish the mail merge, you cannot complete the merge.

    Was this information helpful?

    A mailing list can be created within Word for sending bulk mail during mail merge process.