If Word prompts you, select Sheet1$ and click OK.
Now the Excel spreadsheet’s connected to the mail merge document you’re creating in Word.
To include only some of the people or items from your spreadsheet, click Mailings > Edit Recipient List.
The Mail Merge Recipients box opens. Here, you can select just the rows you want to include. To make them easier to find, you can sort and filter the information.
Or add addresses from your list by clicking Mailings > Address Block. For more information about adding fields from your spreadsheet, see Insert mail merge fields.
I need these instructions for Word & Excel for Mac. I do not have these commands on my computer..
I apologize. I didn't know you had a Mac. There was no mention of it in the information in the original question. Use the revised instructions below for the Mac version.To create the main document, follow these steps:Create the data source
Each column in your Excel sheet contains a category of information, or data field — for example, name, street address, city, state, and postal code. 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.
Important Make sure that the data is in list (list: A series of sheet rows that contain related data, such as an invoice database or a set of client names and phone numbers. A list can be used as a database, in which rows are records and columns are fields. The first row of the list contains labels for the columns.) format. Each column of data must have a label in the first row. There cannot be any blank rows or columns within the list.
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:
Note Later, as you create the labels, you use the fields in the header record to specify what data goes where.
Add as many additional rows of addresses as you want. Your Excel sheet should now look something like this:
Remember where you save the sheet. You will need to know the location later.
Then in Word...
A new, blank Word document opens. This becomes your main document.
Do not type anything (including spaces) in the Delivery address box.
Tip If you can't type inside the Return address box, clear the Use my address check box.
This will complete the merge with the Excel data. Let me know if you have any questions.
Sorry to keep bugging you. Actually I just need to create a valid postal mailing list for a service to do the non-profit bulk mailing. It is a postcard mailing, with about 6000 mailing addresses. I submitted our list last week in .xls & today they wrote back that over 2500 addresses are "not automated" - do not have 100& match with the USPS. I have no idea what this means. So I'm trying to fix & send back. I'm working on a MacBookPro, with word & excel for mac 2011.