Formatting zip code in mail merge from Excel to Word



  • 1. Conversion error when Importing Excel spreadsheet into Word 2003
    I used to be able to import an Excel spreadsheet range into a Word document. I recently upgraded from Office 2000 to Office 2003 and now when I try to import from Excel, I get a conversion dialog box that says, "Select the encoding that makes your document readable." The default is Windows, but I've tried all options and none are readable. The way I've been used to importing these spreadsheets (in Word 2000) is: INSERT | FILE | Select the Excel file name |Select from the dropdown list: SHEET1 | Enter the cell range to insert This allowed me to insert a fully editable/formattable version of my spreadsheet. Can anyone help with this conversion issue?
  • 2. In a protected .dot file how I prevent users from adding spaces?
    I am creating forms with a list and do NOT want the user to be able to add spaces between the lists. ___ This is an example ___ Another line below I do NOT want to the user to be able to depress the ENTER key after the word example and add a line.
  • 3. can I email a word document and have the other person add to it?
    I want to send a list to someone in another city by email. She wants to add to it and edit it then send it back so I can also add to it. Is that possible? when I email it to her she can save it but not work with it.
  • 4. Changing cursor from underline to box.
    Can anyone tell me how to change the flashing cursor in Word to a flashing box for a visually impaired user?
  • 5. Changing style of Level 4 in Outline
    I'm using Word in Office 2003. In Outline View I've created text at 4 levels with headings etc. Each level gets automatically formatted with styles: Heading 1, 2, 3, 4 and so on. But I want to change Level 4 to using a Bullet Text style instead of a Heading style. I feel there must be a way of doing this - but all I can find is the option to change the Heading 4 style but it will still be called Heading 4. I hate the Word help now, find it really hard to use, eg I can't find Outline in the Table of Contents. I have tried to find the answer to my question in offline and online help, but I failed. Do other people hate it?

Formatting zip code in mail merge from Excel to Word

Postby WmlwIGNvZGUgaGVscA » Fri, 11 Feb 2005 03:11:02 GMT

The first zero is lost when I merge my documents. I have read some stuff on 
adding switches but I still can not figure out how to do it. Help!

Re: Formatting zip code in mail merge from Excel to Word

Postby Doug Robbins » Fri, 11 Feb 2005 10:50:07 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's 
website at


Please respond to the Newsgroup for the benefit of others who may be 
interested.   Questions sent directly to me will only be answered on a paid 
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

Similar Threads:

1.Zip code loses leading zero Mail Merge from Excel to Word Labels

Even though formatted as zip codes, I cannot get the leading zero to show in 
my zip codes when using Word mail merge to create address labels.  

Example:  04103 shows up on the label as 4103

2.Mail Merge - Excel Data File to Word - Zip Code

- While using Word 2002 for a mail merge and using an 
Excel 2002 data file with a column for Zip Codes, the 
leading zero for the zip code doesn't appear..

- I couldn't find a patch that would fix it.

- What options do I have?  I would prefer something easy.


3.Mail merging Word and Excel with ZIP codes starting with ZERO

I'm trying to merge an Excel spreadsheet into a word 
document (mailing labels)  I've formatted the column in 
the Excel sheet for "special" ZIP CODE format so that the 
zeroes will appear in the spreadsheet.  However when I do 
the merge, if there is a ZIP+4 a ZERO will show up as the 
zipcode on the label.. in some cases it looks like a 
mathmatical equation.  Example 07761-6909  would be 852 
and 852 would show as the zip code on the mailing label.  
Furthermore, if there was only the standard 5-digit zip 
code on the Excel sheet the zero would be missing 
entirely and it would show the remaining 4 digits of the 
ZIP Code.  What am I doing wrong in this application?  
This is XP, by the way.

4.Mail Merge from Excel to Word-how to set up Zip Code on separate l

When I do a mail merge from Excel to Word the zip code is on the same line as 
the city. How can I set it so the zip code is on a separate/last line?

5.Mail Merge from Excel, losing format of zip codes, one machine onl

As the subject suggests, just one machine is having the problem.
I have a user who can log into other machines here, and the mail merge works 
without problems. BUT on HER machine, the zip codes cells lose their format.

The Excel spreadsheet is fine, because it's shared with other users for 
similar tasks.

So, she can successfully complete the mail merge on any other machine except 

Is it possible the '' file is corrupt?

Thanks in advance.
You want it When??

6. Word Mail Merge and Zip Codes

7. Problem formatting ZIP code in mail merge

8. Mail Merge Zip Code will not format correctly

Return to MS WORD


Who is online

Users browsing this forum: No registered users and 59 guest