When you use and Excel spreadsheet as a data file in a Word mail merge, formatting zip codes can sometimes make you want to tear all the hair out of your head.
This is a particularly annoying problem because most users assume they are solving the problem by correctly formatting zip codes in Excel.
However, correctly formatted zip codes in Excel sometimes still arrive in Word without their leading zeroes. Some users have reported an error message when attempting to set up the DDE connection. The cause for the error can be a variety of reasons such as a filtered spreadsheet or a conflict with a printer driver. If you cannot establish the DDE connection, there is an alternative method to force the leading zeroes in a zip code to microsoft word 2016 mail merge zip code leading zero free in a mail merge.
Check out this post:. Good karma is on its way to you! I am running Word with Windows 8. I tried the process above to fix my issue with missing leading zeroes on my zip codes. I really would appreciate some help. This process will not work if there is a filter set on the Excel spreadsheet. Do you have any filters set, by any chance? If so, just clear them in Excel, save and try again. If you need to filter your recipients, you can do it from the Edit Recipients dialog box in Word after you start the merge.
I hope this helps. Let us know. Cindy, I did some quick research, and in addition to a filter interfering with the DDE connection, this can also be caused by a conflict with a printer driver. If you have any printers installed that you no longer use, you might want to remove them, and also consider removing and reinstalling the default printer, to see if that solves the problem. Let us know if you get it resolved. We will microsoft word 2016 mail merge zip code leading zero free to get that published soon.
Cindy, I just posted instructions on another way to get the leading zeroes to appear, if you cannot resolve the connection problem. When I attempted to change to DDE, it reordered the contents ofthe address box to add my fist column into my address my first column is a category, not he first name Any way to fix this? I found this way is the only thing that worked for me. The site link below explains, but this is the ginst of it:. The latter of the two. Next, use your.
I am sitting here working on merging addresses from my Excel file to Word and these zeroes show up in the zip code and I almost lost it until I remembered Google. I stumble on your article. I followed the steps and it worked like a charm. When I type them in the field they microsoft word 2016 mail merge zip code leading zero free disappear?
How to fix that issue!! ThNk you!! I am using the new version of Excel. I converted the file to. This is amazing. Such an easy fix when you know how. No more typing in the zero manually. You have made my day! I found the easiest way to resolve my zip microsoft word 2016 mail merge zip code leading zero free dilemma is to right click in the zip merge field when in the mailings tab.
I only have one address with the issue. On the envelope and letter heading, it looks as it should. When you take it out of the formatted-for-zip code cell, the leading 0 merges along with the rest of the data and prints out normally. It works, which is great, this has given me headaches from time to time, I hope this continues to work.
Only options are to type in a cell range no option for specific worksheet or entire spreadsheet. So, now I have to create a separate workbook for each worksheet…. Would very much recommend using the TXT option as it is not unusual to have commas in the addresses, and those will end up separating your data unintentionally. I almost gave up…but thanks to your easy to read step by step instructions-I got it! Your email address will not be published.
Save my name, email, and website in this browser for the next time I comment. Skip to primary content. Skip to secondary content. Using Range. Here is one way to fix the problem permanently: Start Word, and then open a new blank document. On the Advanced tab, go to the General section. Click to select the Confirm file format conversion on open check box, and then click OK. Start the mail merge and then select your recipients by navigating to the Excel spreadsheet that contains your data.
Excel will display the following dialog: In the Confirm Data Source dialog box, click to select the Show all check box. In the Microsoft Excel dialog boxunder Named or cell rangeselect the cell range or worksheet that contains the data that microsoft word 2016 mail merge zip code leading zero free want to use, and then click OK.
Next, add merge fields to your main document labels, envelopes, etc. When you preview or finish the merge, the zip codes will format correctly with leading zeroes the way they appeared in the Excel spreadsheet.
Thank you — this was driving me crazy! Your 2 minute fix replaced my 1 hour search for a solution!! Happy New Year to all —. A working solution. Leave a Reply Cancel reply Your email address will not be published.
Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search. I'm trying to do a simple mail merge in Word but when I insert an excel field that's supposed to represent a zip code from Connecticut ie.
Perhaps is there something in my excel spreadsheet or an option in Word that I need to set to make this properly work? Please advise, thanks. See macropod's post in this conversation. However, if you are mixing text and numeric formats in your Excel column, there is a danger that the OLE DB provider or ODBC driver - if that is what you are using to get the data - will treat the column as numeric and return all the text values as 0.
Yes, Word sometimes treats text strings as numeric expressions as you have noticed. Word takes it all at face value then. Stack Overflow for Teams — Start collaborating and sharing organizational knowledge.
Create a free Team Why Teams? Learn more. Asked 9 years ago. Modified 7 years, 1 month ago. Viewed 2k times. Improve this question. Add a comment. Sorted by: Reset to default. Highest score default Date modified newest first Date created oldest first.
Improve this answer. Georges Brisset Georges Brisset 2 2 silver badges 6 6 bronze badges. In the general case, this isn't enough to solve the problem, unless the user is connecting to Excel using DDE. Text values in the column will come through to Word as 0. So ' will be treated as 0. So not so "simply"! Laura Haglund Laura Haglund 1. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.
The Overflow Blog. Run your microservices in no-fail mode Ep. Featured on Meta. Announcing the arrival of Valued Associate Dalmarus. The [comma] tag is being burninated. Related 4. Hot Network Questions.
Question feed. Accept all cookies Customize settings.