Mail Merge Inserting 0's

[Bruinsma]

I am using a mail merge, merging from an excel file. The data in Excel
contains the word "Delete". For some reason when it pulls it through the
merge, the first 3 lines of the document insert 0's instead of the word
"Delete". Every entry thereafter pulls in just fine. Any ideas??

 

[Graham Mayor]

Check the validity of the data in the first three records in the Excel file.
Alternatively, use a conditional field
{IF {Mergefield fieldname} <> "0" "{Mergefield fieldname}"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>