"too few data" error

[Lisa]

We do A LOT of merges here, and this problem comes up
when my excel file (we save as a .csv) has many blank
cells--this occurs when we have little information on our
constituents--the cells are supposed to be blank. When I
perform the merge (using Office 2003) in the word doc it
pops up "too few data" for every record that has blanks.
I just want the darn thing to skip that line like it is
supposed to. Instead it refuses to print that particular
record. I searched microsoft online and found 1 article
from Office 2000, that makes no sense. Oh, and if I go
back to my source file and "find and replace" all the
blanks with a . or something, then the merge works fine,
but takes 10 years to print because it has to "think"
about the 10,000+ .'s it has to print. Please help!!!

Oh, and in case you are wondering, if I save my excel
file as a .xls I lose special formatting (like shortened
dates) in my merge doc. Either way I am in trouble.

 

[Doug Robbins]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP