1) Create Useful Field Names in Excel 2007
To start making your mailing labels, open up Excel and create useful field names in the first row. Note, as illustrated in the Figure, that each column represents one and only one field name. You could, of course, just use Excel’s column labels (A, B, C, etc.), but when you want to insert the field names into Word, you will find that descriptive field names are easier to use. The typical field names used for mailing labels are:
State (or Province)
Zip Code (or Postal Code)
However, you are not limited to these fields. In fact, you can include any information you want. For example, you may want to include a title field (Mr. Ms. Dr., etc.), a date field (September 23rd, 2009), or a business name field. You need to include any fields you intend to print on your mailing labels. However, you do not need to use all of the fields in the Excel file on your labels; you may have a “title" field in your Excel file, but that does not mean you must use each person’s title on the labels. You may simply have that information included in the Excel file for some other use.