Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Field doesn't display complete number
I have a database in excel that I'm using to merge letters. I'm having
trouble in getting the nine digit zipcode to display. In excel it displays as 12345-4567 in the field. In WORD I've used this merge field { Mergefield "INVOFCZIP" } It returns a 0 when I have a nine digit zip code in the datacell. When I have a 5 digit it prints properly. I really need the 9 digit, how can I get it to go that way. Is there a switch for the 9 digit zip or something. Thanks in advance Bob |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Field doesn't display complete number
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 "rjr" wrote in message ... I have a database in excel that I'm using to merge letters. I'm having trouble in getting the nine digit zipcode to display. In excel it displays as 12345-4567 in the field. In WORD I've used this merge field { Mergefield "INVOFCZIP" } It returns a 0 when I have a nine digit zip code in the datacell. When I have a 5 digit it prints properly. I really need the 9 digit, how can I get it to go that way. Is there a switch for the 9 digit zip or something. Thanks in advance Bob |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using IF to find whether a Merge Field contains a substring | Mailmerge | |||
How do I format a phone number in a mail merge field? | Mailmerge | |||
Merge field control in Documents | Mailmerge | |||
Database Query on Merge field | Mailmerge | |||
How to limit the number of characters in a mail merge field | Mailmerge |