You have to do it in Word. This page includes instructions on how to reveal the field codes in Word: http://www.grbps.com/raq17.htm Ray ------------------------------------ GR Business Process Solutions Ray Blake Head of Software Design ray@xxxxxxxxx Braedon Newell Road Hemel Hempstead Herts HP3 9PD tel: 01442 396518 fax: 01442 389353 mobile: 07834 226601 www.grbps.com ------------------------------------ -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Jan Robey Sent: 10 December 2005 13:51 To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Labels dropping the 0 in Zips Hi Ray, OK...how do I add a picture switch? I did it to the Excel but it made no difference in the Word labels. In Word I don't know where or how. ----- Original Message ----- From: "Ray Blake" <ray@xxxxxxxxx> To: <mso@xxxxxxxxxxxxx> Sent: Friday, December 09, 2005 6:15 PM Subject: [mso] Re: Labels dropping the 0 in Zips You need to add a picture switch to the merge field to fix this. At the moment, your field is probably something like this: {mergefield zip} You need to insert a switch to end up with: {mergefield zip \# "00000"} Ray Please someone bail me out! I am trying to mail merge labels in Word 2002, my OS is XP. In Excel I formatted the cells in my Zip Code column to custom 00000. When saved in Excel all 5 numbers are visible, but when it goes into Word, if 05555 is the zip, only 5555 will print. It will not allow me to edit the data once word has set it up as a label. I hope I explained this problem clearly so you can help me resolve this problem. Thanks Jan ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************