To make sure your ZIP or postal codes come through a mail merge without losing any zeros, format the ZIP or postal code column as text.
- In your Excel spreadsheet, select the column you want to format.
- Right-click, and then click Format Cells.
- On the Number tab, click Text.
If your spreadsheet includes dates, decimals, monetary amounts, or other numbers, you can use Dynamic Data Exchange to make sure those values come through the merge without losing the formatting in your Excel spreadsheet.
If you’re just starting out and want to import addresses from a .csv or .txt file, your best bet is to use the Text Import Wizard.
Mail merge with dates, currencies, and other numbers
To merge numbers that have formatting, such as dates, decimals, and currencies, use Dynamic Data Exchange. With Dynamic Data Exchange, you’ll get the mail merge results you want, and you keep the formatting of your Excel spreadsheet. Here’s how:
- In Word, click File > Options > Advanced.
- Scroll to the General section, and select the Confirm file format conversion on open check box.
- Click OK.
After you start your mail merge and choose the kind of merge you want to run, it’s time to connect to your data list. Because Dynamic Data Exchange is turned on, you’ll receive a few extra prompts.
- In the mail merge document, click Mailings > Select Recipients > Use an Existing List.
- Browse to your spreadsheet, and double-click it.
- Click MS Excel Worksheets via DDE (*.xls), and then click OK.
- If you don't see MS Excel Worksheets via DDE (*.xls), select the Show all check box.
- Click Entire Spreadsheet, and then click OK.
Now continue with your email, label, or document merge.
Tip To prevent being prompted by Word every time you open a data file, you can open Word Options again and clear the Confirm file format conversion on open check box after you connect to your mailing list.
Import an address list
If you want to use information from a .txt or .csv file (for example, if you exported your Hotmail contacts into a .csv file), import that information into Excel by using the Text Import Wizard. Here’s how:
- Start Excel.
- Click Data > From Text.
- Click the .csv or .txt file you want, and then click Import.
- In the Text Import Wizard, click Next.
- In step 2, click the delimiter that your data uses (the Data preview window shows you what the results will look like).
- In step 3, click the column that has postal codes, dates, currencies, or other values, and then click Text under Column data format.
- Repeat step 6 for each column you want to format.
- Click Finish.