![how to do a mail merge in word 2003 from excel how to do a mail merge in word 2003 from excel](https://www.howtogeek.com/wp-content/uploads/2007/05/WindowsLiveWriter/CreateMailingLabelsWord2003WithMailMerge_DCE6/labels_1.png)
If you're creating mailing labels, click Labels in Step 1, and then click Label options in Step 2 to select the size and type of labels to print.įor more information about these steps, see Word Help. In the first two steps of the Mail Merge Wizard, select the document type and start the document.On the Tools menu, point to Letters and Mailings, and then click Mail Merge Wizard.Save and close the workbook that contains the data.On the Insert menu, point to Name, and then click Define.To make the list easy to find when you select it for the mail merge, give it a name:.Smith, you can use a single column containing both titles and last names, or use one column for title and another for last name. If you want to refer to each recipient by title and last name, such as Mr. For example, if you're creating form letters and want to use each recipient's first name in the body of the letter, make sure you have a column that contains first names, rather than a single column with both first and last names.
![how to do a mail merge in word 2003 from excel how to do a mail merge in word 2003 from excel](http://www.outofhoursadmin.ie/wp-content/uploads/2012/04/Tools-menu1.jpg)
![how to do a mail merge in word 2003 from excel how to do a mail merge in word 2003 from excel](https://i.pinimg.com/originals/a5/0c/93/a50c9336b82099491d39c5886f13a3ba.jpg)
Make sure you have a separate column for each element that you want to include in the mail merge.For example, labels such as First Name, Last Name, Address, and City are better than Column 1, Column 2, Column 3, and Column 4. Make sure the column labels clearly identify the type of data in the column this helps you select the right data as you construct the mail merge.You'll use the column labels to specify what data goes where in the mail merge. Make sure the data is in list format: each column has a label in the first row and contains similar facts, and there are no blank rows or columns within the list.