I have a user who has an address listing in Excel which includes both the standard 5 digit zip code and the expanded 5+4 zip code. She wants to use this data list to print mailing labels. After she runs the Mail Merge Wizard in Word (2002) and selects her data for printing the labels, the zip codes with the 5+4 format appear as 0?s. We tried removing the dash in the longer digits and changing the format in the Excel datasheet to the 5+4 format but in the merge, it still shows 0?s for those zips.
Neither of us are expert Excel users and I have been unable to find an answer to this. She ended up this time removing the +4 digits but in the future, she would like to be able to use the entire zip code.
Any help would be greatly appreciated!!
Thank you.
