How To Fix Broken Zip Codes in Excel & Word Mail Merge




About this tutorial:

Video duration: 3:42

social@navitend.com

How to fix broken zip codes in Microsoft Office Excel and Word Mail Merge. The problem arises when a zip code begins with a zero, because Excel and Mail Merge strip these zeros by default! Follow these steps for a solution.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

37 thoughts on “How To Fix Broken Zip Codes in Excel & Word Mail Merge

    AH 1019

    (February 20, 2020 - 9:59 pm)

    how do you add the hyphen on nine number zip codes

    Fred Busler

    (February 20, 2020 - 9:59 pm)

    Good stuff. Thanks

    Torah Ohr

    (February 20, 2020 - 9:59 pm)

    I know this is an old video – but does anyone know how to get Canadian zip codes to show up? Right now they are showing up as 0 in the mail merge

    Robert Rumfelt

    (February 20, 2020 - 9:59 pm)

    Great job – thanks!

    Morena Jackson

    (February 20, 2020 - 9:59 pm)

    Thanks so much, this saved me from pulling my hair out.

    Lucia Nepola

    (February 20, 2020 - 9:59 pm)

    Great video! Now how do you add the hyphen on nine number zip codes?

    Joanna Campagna-Fertucci

    (February 20, 2020 - 9:59 pm)

    Thank you for this video! Such a time saver!!

    Beverly Liu

    (February 20, 2020 - 9:59 pm)

    2:42 is when video shows Shift F9 and provides the solutions to show zip code in a mail merge

    Lindsay Vance

    (February 20, 2020 - 9:59 pm)

    Thank you so so much. This helped me to fix an issue with member ID numbers that also start with zero. 🙂

    jugglaz1948

    (February 20, 2020 - 9:59 pm)

    This surely helped me out of a bind today. Thank you!

    Kris Stewart

    (February 20, 2020 - 9:59 pm)

    thanks for the tip

    michael m

    (February 20, 2020 - 9:59 pm)

    Your an OG! Lol I just wanted to let you know this video is still saving mailing addresses one envelope at a time. That is a great tip no "buts" about it! You saved me a shit ton of time considering I was missing a 0 for 305 mailing addresses. I attempted to use "zip code" format then I tried using a custom formula in excel "0000#". Finally I just put a 0<Zip> then updated labels and it fixed all entries but I prefer using a formula if possible. Thanks again, I logged in to YouTube just to leave this review!

    Duluth Bible Church

    (February 20, 2020 - 9:59 pm)

    We mail hundreds of journals out every year and I have been fighting this issue since the late 90's. Thanks to this video I don't have to go in and add zeros manually to all of our subscribers in the New England states. Thank you very much for this helpful video!

    Jay Patterson

    (February 20, 2020 - 9:59 pm)

    Solved my problem! Thank you!

    Bill Dolloff eXp Realty

    (February 20, 2020 - 9:59 pm)

    Alt or shift F9 opens the volume control in my version of word. Can't figure out how to open that zip code dialogue box. Suggestions?

    Erika Q Stokes

    (February 20, 2020 - 9:59 pm)

    Thank you!

    Rita Willmer

    (February 20, 2020 - 9:59 pm)

    Exactly what I needed, thank you !

    TE

    (February 20, 2020 - 9:59 pm)

    I love this so I can get my students dojo up dojo down

    Chris Collman

    (February 20, 2020 - 9:59 pm)

    Still love this 2011 video. Apparently, Word 2013 will recognize the Excel zip and zip-4 formats. Insert the address block or the zip field, no special coding required. Microsoft must have heard Steve Raymond and a million others about that issue. TIP, bet it has to be an xlsx and docx version of files. I ran into the leading 0 problem when somebody sent me a file that was in .xls and doc format.

    Stephanie Mott

    (February 20, 2020 - 9:59 pm)

    THANK YOU. 1) My mind = blown. 2) Saved me so much time – easiest solution ever!

    Lee Brent

    (February 20, 2020 - 9:59 pm)

    I could live to be 1,000 and never get this right…THANK YOU!
    My wife really thanks you.
    Lee

    Lora Beck

    (February 20, 2020 - 9:59 pm)

    Thank you very much in sharing this information! Very helpful!!

    Steve Raymond

    (February 20, 2020 - 9:59 pm)

    This is what makes me crazy about Windows… such an obscure programming fix for what has to be a very common user problem. I spent 2-hours trying to solve this problem. Thank you for this great fix. To Marc Bessler, I would say separate your 4-digits into a separate field.

    Mary Smeriglio

    (February 20, 2020 - 9:59 pm)

    Thank you very much! The fix you recommended was fast and easy. Appreciate your help.

    John Amo Doyle

    (February 20, 2020 - 9:59 pm)

    THANK YOU

    larn555

    (February 20, 2020 - 9:59 pm)

    any idea how to do this on a mac with word 2011?

    Marc Bessler

    (February 20, 2020 - 9:59 pm)

    This is a great video and thank you for posting. However, it unfortunately does not solve the problem if you column has a mix of Zip and Zip+4 codes in it. Even worse if your column has Zip, Zip+4, and international. Any thoughts on a solution?

    michael colameta

    (February 20, 2020 - 9:59 pm)

    awesome awesome thank you

    Deshone Drummond

    (February 20, 2020 - 9:59 pm)

    I don't get why it didn't work. When I bring the Excel file over to Word it's showing without the 0's data list. It doesn't seem to be carrying the 0's over at all from Excel. Can you say frustrated? Thanks though

    Jeffemano

    (February 20, 2020 - 9:59 pm)

    I suggest that you bomb MS support page with a link to this video so they can get their shit together and show actual helpful information.

    Felix Silva

    (February 20, 2020 - 9:59 pm)

    How can I find zip codes that start with zero in excel?

    1Aran7

    (February 20, 2020 - 9:59 pm)

    Not only would've never figured out how to do this, id be out at least 1 monitor, mouse, keyboard and possibly the computer its self if i had enough energy to throw it out the window too.
    Thanks!

    temmy790

    (February 20, 2020 - 9:59 pm)

    i just wanted to fix my jacket zip or something then it brought this shit :/

    navitend

    (February 20, 2020 - 9:59 pm)

    Thanks for the feedback!

    OneMaleHuman

    (February 20, 2020 - 9:59 pm)

    What I've been doing is simply using the Find & Replace function to find "NJ_" and replace it with "NJ 0". Then I suppose I'd have to repeat it for CT and any other states that have zips that start with 0. So ALT F9 is still handy.

    iwillfoolu

    (February 20, 2020 - 9:59 pm)

    This is a useful video. Thank you.

    Karlee Drumgool

    (February 20, 2020 - 9:59 pm)

    Thank you soo much!! Very big help!

Leave a Reply

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