MS Word 2007 Mail Merge fails on ZIP codes with leading Zeros (eg. 01234)

Posted by Pretzel on Super User See other posts from Super User or by Pretzel
Published on 2010-06-10T03:13:32Z Indexed on 2010/06/10 3:24 UTC
Read the original article Hit count: 502

Filed under:

microsoft-word

|

mail-merge

|

microsoft-excel

I have an Excel Spreadsheet with a ZIP code column. For some dumb reason the original spreadsheet I got had all the zip codes stored as numbers, so a ZIP code like 01234 was stored as 1234. Easy to fix with "Format Column" as "Special => ZIP Code". All values like 1234, show up as 01234. Great!

When I import it into Word via Mail Merge (to print address labels), the ZIP codes on all the addresses starting with a leading zero (like 01234) revert to their old form (1234).

How do I fix this?

© Super User or respective owner

Related posts about microsoft-word

Easy Update "Table of Contents" feature in Microsoft Word 2007 VS. Microsoft word 2010

as seen on Super User - Search for 'Super User'
I am currently working on a document that was written using Microsoft Word 2007 and I am also using Microsoft Word 2007 to update the document. It is just the way of the workplace I am now in. I have noticed that the feature of adding nested headers ("subheaders" perhaps) does not work the same… >>> More
Microsoft Word 2007 opening all docs with field codes toggled off

as seen on Super User - Search for 'Super User'
Recently, something changed with my Microsoft Word 2007 installation/preferences on Windows XP, such that whenever I open a word document, all the field codes are displayed raw instead of as their expanded value. For example, my header reads: My Name { TITLE \* MERGEFORMAT } Version { REVNUM… >>> More
Microsoft Word - Word count excluding specific Styles?

as seen on Super User - Search for 'Super User'
Hi, I was wondering if there's a way to get a word count that excludes text with a specific Style in a Microsoft Word 2007 document? I've seen this related question, but I've got blocks of source code scattered throughout which would mean I'd have to go through each of my documents a section at… >>> More
Microsoft Word restores all open documents when clicking on a .DOC file

as seen on Super User - Search for 'Super User'
I tend to have a few Word documents that I keep open all the time, with notes for a long-running project. Normally they are all minimized. The problem is that when I click on a different .doc or .docx file in Windows Explorer, even though the new document opens in its own window, the other, minimized… >>> More
How to open Microsoft Word by function call?

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to open a word document through my program in C# and document path to read or write to. 2.To change the formatting of text in the word document as if i wanted the word window to give me the text in RTF format or plain text or docx (supported formats) 3.If i can retrieve the text in my given… >>> More

Related posts about mail-merge

Switch Text Paragraphs in OpenOfficeOrg Writer mailmerge

as seen on Super User - Search for 'Super User'
I am using mailmerge to write the same letter with minor differenes to many peolpe. I experienced that switching text paragraphs depending on database values was not easy for me. I ended up putting huge text paragraphs into the database becaus switching did not really work for me. Actually I dont'… >>> More
mail merge e-mail in Word 2007 with attachment

as seen on Super User - Search for 'Super User'
Is there a simple way to mail merge with Word 2007 and add an attachment? I've searched google, and all results point to pasting in VB code. I want to a small team of novice users to be able to mail merge e-mails and add attachments. Does anyone know a simple way of doing this without code? >>> More
Electronic Postage provider compatible with Microsoft Word Mail Merge

as seen on Super User - Search for 'Super User'
We're looking for an e-postage provider that is capable of working with the Mail Merge function in Microsoft Word 2007. Every now and then we extract addresses from our database to mail letters or notices. We use Mail Merge in Word 2007 to print the address information straight to the envelopes and… >>> More
Remove mailmerge data source via OpenXML

as seen on Stack Overflow - Search for 'Stack Overflow'
I have some code that uses OpenXML to open up a docx file, find all mailmerge fields, and replace them with data (ignoring the datasource that may have been provided). I initially tested this against a document created in Office 2007 and it seemed to work great. We then created one in 2003 based… >>> More
Question about mail merge in DesignPro 1.0.1 for mac

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Avery DesignPro v. 1.0.1 for mac to print out address labels using a mail merge. There are two columns for addresses (Address1 and Address2), but for most of the entries on the list, Address2 is blank. When I do the mail merge, I get several address labels with a blank line between Address1… >>> More