If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Office 2007 Mail Merge Zip Code
In using Office 2003 I didn't have this problem. I upgraded to Office 2007.
When I do the mail merge the first "0" in the zip code is dropping off. I have the cells formated for zip code and it is still doing the same thing. |
#2
|
|||
|
|||
Office 2007 Mail Merge Zip Code
If you click on the Office button and then on Word Options in the bottom
border of the dialog and then go to the Advanced group and then scroll down to the General section and check the box for "Confirm file format conversion on open", when you attach the data source to the mail merge main document, you will be presented with a dialog that allows you to select the method by which the connection should be made. If you select the DDE option, the zip codes will probably be displayed correctly. Alternatively, see the article "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at: http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "JayRay" wrote in message ... In using Office 2003 I didn't have this problem. I upgraded to Office 2007. When I do the mail merge the first "0" in the zip code is dropping off. I have the cells formated for zip code and it is still doing the same thing. |
Thread Tools | |
Display Modes | |
|
|