I am using Mac OS X 10.8.3. I downloaded Word and Excel for Mac Version 14.2.0.
The Mail Merge Manager built into Microsoft Word for Mac makes it easy to import, then edit and print. See the steps to mail merge from an Excel spreadsheet onto an Avery template, making preparing for mailings and meetings a breeze.
I am trying to use the mail merge feature and every time I choose my Excel spreadsheet (in.xlsx format )as my 'open data source' a pop up window tells me it has to be converted. In choosing every option given to convert, it tells me the file cannot be read. I tried saving my Excel spreadsheet in.xls format and it still doesn't work. I am sure my Excel spreadsheet is formatted correctly. Is it just not possible with this version of Word and Excel or is my OS dated???? This is driving me crazy.
By With Office 2011 for Mac, your guide to mail merging in Word is Mail Merge Manager. You can invoke Mail Merge Manager by choosing Tools→Mail Merge Manager from the menu bar.
It’s designed to be used starting at the top in Step 1, and you work your way down to Step 6. The steps in the Mail Merge Manager are as follows:. Select a Document Type. Choose from four types of mail merge:. Form Letters: Customize a letter with personal information or data.
Labels: Make mailing labels, tent cards, book labels, and DVD labels. Envelopes: Print envelopes of any size. Catalog: Choose this option to build custom, personalized catalogs, brochures, and price sheets. For example, you could pull pictures from a database to create individualized custom catalogs based on customer purchases, category, or some other criteria.
Select Recipients List. Choose a data source for the mail merge. Insert Placeholders. Choose the field names (for example, column names, headers, and column headers) and position them in your document. Filter Recipients. Set rules as to which records will be retrieved from the data source. Preview Results.
See exactly how your document looks with data before running the mail merge. Complete Merge.
Run the merge. You can merge to a printer, a single Word document, personalized Word documents, or e-mail messages.