Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Frustrated with Excel and Word merge
Hello, I am not sure if the problem lies with Word or Excel, so I am posting
this on both discussion group. I have been trying to figure out the source of this error for several hours without any results and hope someone can help me. I have been using an Excel file to create a merge letter in word. So far it has been working like a charm and the problem started just after I entered some new records. In my word merge letter after the City, State, and Zip fields, I have a word field, which is set to insert a hyphen after Zip field if "zip suffix field is not blank". (The "otherwise insert this text" is left blank). This is followed by the zip suffix field. This is intended to show both the zip and zip suffix separated by a hyphen if some addresses do have a zip suffix. So far, this has worked fine, but after my latest entry of new records in the Excel worksheet, green corners started appearing in the zip and zip suffix fields though both the fields are formatted as text. I manually clicked "ignore this error" and the flags went away. However, now whenever I am merging, for most of the old records, the State, zip and zip suffix are appearing as they should (e.g., PA 18723-1234 or PA 18723), but for all the new records that I have just entered, the Zip and zip suffix are appearing as 0 (when there is no zip suffix) and as 0-0 when there is a zip suffix. I am stumped and am unable to figure out why this is happening. What went wrong? Can someone please help? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
How do I merge Word document with Excel one? | Microsoft Word Help | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
How do I create & merge specific data base & master documents? | New Users | |||
Excel worksheet in Word linked text boxes | Page Layout |