 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / June 2005MailMerge error
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_into_mail_merge.htm  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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! > 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 [quoted text clipped - 9 lines] > > 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. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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 [quoted text clipped - 24 lines] >>> 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 > 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 [quoted text clipped - 9 lines] > > merging, which are empty but not the columns I am merging. They all > > have data present. Any ideas? Thanks for your help! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.