Mail Merge with leading zero’s (0’s) [Solved]

Mail Merge with leading zero’s (0’s) [Solved]

 

Word 2007 and Word 2010

  1. In Excel, select the column that contains the ZIP Code/Postal Code field.
  2. On the Home tab, go to the Cells group. Then, click Format, and then click Format Cells.
  3. Click the Number tab.
  4. Under Category, click Text, and then click OK.
  5. Save the data source. Then, continue with the mail merge operation in Word.

Word 2002 and Word 2003

  1. In Excel, select the column that contains the ZIP Code/Postal Code field.
  2. On the Format menu, click Cells.
  3. Click the Number tab.
  4. Under Category, click Text, and then click OK.
  5. Save the data source. Then, continue with the mail merge operation in Word.

Mail Merge with leading zero’s (0’s) [Solved]

Leave a Reply

Your email address will not be published. Required fields are marked *