Using a .csv spreadsheet for envelopes - 86 records. When I merge, I get an
error message stating "record 32 contained too few data fields" - I must hit
OK and then it says the same thing up to record 86. As I look at the
spreadsheet, there are columns, which I am not merging, which are empty but
not the columns I am merging. They all have data present. Any ideas?
Thanks for your help!

A csv format file is not a spreadsheet, but a comma delimited text file, and
it seems that in the quoted records a comma is missing. The merge requires
all the 'columns' to be correct, not merely those you are merging. The
simplest plan is to open the csv file in Word and convert the text to a
table - see the relevant part of
http://www.gmayor.com/convert_labels...mail_merge.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



giddne wrote:
Using a .csv spreadsheet for envelopes - 86 records. When I merge, I
get an error message stating "record 32 contained too few data
fields" - I must hit OK and then it says the same thing up to record
86. As I look at the spreadsheet, there are columns, which I am not
merging, which are empty but not the columns I am merging. They all
have data present. Any ideas? Thanks for your help!

Thanks Graham. Originally it was an Excel file but I converted it to .csv on
the recommendation of a friend. I could never get it to merge because I kept
getting an error message - "Word could not re-establish a DDE connection to
excel to complete the task". Is there a way I could use the .xls file
without converting it? Would certainly make it easier. Thanks for your time
and input!

"Graham Mayor" wrote:

A csv format file is not a spreadsheet, but a comma delimited text file, and
it seems that in the quoted records a comma is missing. The merge requires
all the 'columns' to be correct, not merely those you are merging. The
simplest plan is to open the csv file in Word and convert the text to a
table - see the relevant part of
http://www.gmayor.com/convert_labels...mail_merge.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



giddne wrote:
Using a .csv spreadsheet for envelopes - 86 records. When I merge, I
get an error message stating "record 32 contained too few data
fields" - I must hit OK and then it says the same thing up to record
86. As I look at the spreadsheet, there are columns, which I am not
merging, which are empty but not the columns I am merging. They all
have data present. Any ideas? Thanks for your help!

One more comment Graham - I'm using Word 2000

"Graham Mayor" wrote:

A csv format file is not a spreadsheet, but a comma delimited text file, and
it seems that in the quoted records a comma is missing. The merge requires
all the 'columns' to be correct, not merely those you are merging. The
simplest plan is to open the csv file in Word and convert the text to a
table - see the relevant part of
http://www.gmayor.com/convert_labels...mail_merge.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



giddne wrote:
Using a .csv spreadsheet for envelopes - 86 records. When I merge, I
get an error message stating "record 32 contained too few data
fields" - I must hit OK and then it says the same thing up to record
86. As I look at the spreadsheet, there are columns, which I am not
merging, which are empty but not the columns I am merging. They all
have data present. Any ideas? Thanks for your help!

Word 2000 can use an XLS file as a data source without conversion, even more
simply than the later versions.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


giddne wrote:
Thanks Graham. Originally it was an Excel file but I converted it to
.csv on the recommendation of a friend. I could never get it to
merge because I kept getting an error message - "Word could not
re-establish a DDE connection to excel to complete the task". Is
there a way I could use the .xls file without converting it? Would
certainly make it easier. Thanks for your time and input!

"Graham Mayor" wrote:

A csv format file is not a spreadsheet, but a comma delimited text
file, and it seems that in the quoted records a comma is missing.
The merge requires all the 'columns' to be correct, not merely those
you are merging. The simplest plan is to open the csv file in Word
and convert the text to a table - see the relevant part of
http://www.gmayor.com/convert_labels...mail_merge.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



giddne wrote:
Using a .csv spreadsheet for envelopes - 86 records. When I merge,
I get an error message stating "record 32 contained too few data
fields" - I must hit OK and then it says the same thing up to record
86. As I look at the spreadsheet, there are columns, which I am not
merging, which are empty but not the columns I am merging. They all
have data present. Any ideas? Thanks for your help!