Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to turn off postal code numeric conversion?
Trying to create address labels from an excel worksheet but word converts the
postal code to number format so I lose all zip + 4 and foreign postal codes. How do I keep the text formating? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to turn off postal code numeric conversion?
You may be able to do it by selecting Options from the Tools menu and then
going to the General tab and checking the box against the "Confirm conversions at open" item. After doing that, when you attach the data source to the mail merge main document, you will be asked for the method by which the connection should be made. Try the DDE option. Also see "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 "MN Jim" MN wrote in message ... Trying to create address labels from an excel worksheet but word converts the postal code to number format so I lose all zip + 4 and foreign postal codes. How do I keep the text formating? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to turn off postal code numeric conversion?
Doug,
I tried the options change and the DDE load option and it worked great! Thank you. Jim "Doug Robbins - Word MVP" wrote: You may be able to do it by selecting Options from the Tools menu and then going to the General tab and checking the box against the "Confirm conversions at open" item. After doing that, when you attach the data source to the mail merge main document, you will be asked for the method by which the connection should be made. Try the DDE option. Also see "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 "MN Jim" MN wrote in message ... Trying to create address labels from an excel worksheet but word converts the postal code to number format so I lose all zip + 4 and foreign postal codes. How do I keep the text formating? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
postal code with extension | Mailmerge | |||
no postal code in mail merge label | Mailmerge | |||
Postal code shows "0" when non-numeric characters present | Mailmerge | |||
Word 2000 Postal Bar Code | Page Layout | |||
Errors in Postal bar code | Mailmerge |