For more info, see Data sources you can use for a mail merge.įor more info, see Mail merge: Edit recipients.įor more info on sorting and filtering, see Sort the data for a mail merge or Filter the data for a mail merge. Connect and edit the mailing listĬonnect to your data source. The Excel spreadsheet to be used in the mail merge is stored on your local machine.Ĭhanges or additions to your spreadsheet are completed before it's connected to your mail merge document in Word.įor more information, see Prepare your Excel data source for mail merge in Word. For example, to address readers by their first name in your document, you'll need separate columns for first and last names.Īll data to be merged is present in the first sheet of your spreadsheet.ĭata entries with percentages, currencies, and postal codes are correctly formatted in the spreadsheet so that Word can properly read their values.
Make sure:Ĭolumn names in your spreadsheet match the field names you want to insert in your mail merge. As you click, new records are injected into your document.Here are some tips to prepare your Excel spreadsheet for a mail merge. You do this in step five by clicking on the View Merged Data icon and clicking the right or left arrow buttons to move through the forms. This is a problem however, as they do not actually send. I get to the stage where I click Mal Merge to Outbox and the messages appear in the Drafts folder of Outlook. The Mail Merge Manager built into Microsoft Word for Mac makes it easy to import, then edit and print. If you like, you can preview your form letter to make sure it’s constructed properly. I am using Outlook 2011 for Mac, and trying to send a mass email using mail merge. If you use Microsoft Office 2011 on a Mac computer, you can easily import addresses or other data from an Excel spreadsheet or from your Apple Contacts and add them to Avery Labels, Name Badges, Name Tags or other products. Once you’ve selected the groups you want to include, click OK. In this specific case you choose groups of Address Book recipients.
Click Options and a Query Options window appears. In step four you determine which of your recipients are merged into the letter. Drag the appropriate data types to their proper place in your form letter. Here you’ll find common data types including first name, last name, address, phone number, and e-mail address. Return to the Mail Merge Manager window and click the third step. Now start constructing your form letter, leaving spaces where you want to merge your data. For our purposes, choose Apple Address Book.
Your options include New Data Source, Open Data Source, Office Address Book (the one found in Outlook), Apple Address Book (Apple’s Address Book application), and FileMaker Pro. In the second step click on Get List and choose the source for the data that will be inserted into your form letter-names, addresses, and phone numbers, for example.
0 kommentar(er)
