![]() |
|
#1
|
|||
|
|||
|
Hello folks,
Mailmerge is new for me so I apologize for the elementary question. I have several fields in Excel that are blank. When these fields get mapped into the Word document, they are appearing as zero (0). If the value coming from Excel is blank, I want the field to display as blank on the Word document. Below is the latest example I have tried, but it does not work. Can someone help me with this? Thanks in advance. {MERGEFIELD Petitioner_Att_Bar {IF {Mergefield Petitioner_Att_Bar} <> "" "{IF {Mergefield Petitioner_Att_Bar <> "0" "{Mergefield Petitioner_Att_Bar}" ""}" ""} \* MERGEFORMAT} |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Suppress blanks in mail merge
|
0nyx175 | Mail Merge | 11 | 01-07-2014 02:45 PM |
Easy mail merge but want to suppress rows
|
ClaireAMAdams | Mail Merge | 5 | 04-30-2013 02:43 PM |
How to auto add up the sum of monetary values?
|
mikehende | Excel | 6 | 10-13-2012 12:40 AM |
Suppress the Save prompt
|
UTSUPPORT | Word | 1 | 01-16-2012 09:27 PM |
| Suppress Dialog Box | crutch024 | Word | 0 | 08-17-2010 09:52 AM |