Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"0" from Excel Data
Hello
I'm having problems configuring my mergefields to report a blank as opposed to a "0" from an empty MSExcel field. These are text fields, but I can't figure out how to set up the IF..THEN test. Any help would be appreciated. Thank you Jeff |
#2
|
|||
|
|||
{ IF { MERGEFIELD fieldname } "" "{ MERGEFIELD fieldname } "" }
using Ctrl+F9 to insert the field delimiters { }and Alt+F9 to toggle of the display of the field codes. -- 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 "Jeff Caldwell" wrote in message news Hello I'm having problems configuring my mergefields to report a blank as opposed to a "0" from an empty MSExcel field. These are text fields, but I can't figure out how to set up the IF..THEN test. Any help would be appreciated. Thank you Jeff |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why isn't all my Excel data merging into my Word labels document? | Mailmerge | |||
Copying Excel data into Word: setting the Tabs | Page Layout | |||
Difficulty pasting Excel data into Word table only in XP versions | Tables | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Word Field Codes in Excel data file | Mailmerge |