A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Too few data fields" error during .csv mail merge



 
 
Thread Tools Display Modes
  #1  
Old November 10th, 2004, 07:17 PM
Chris Singer
external usenet poster
 
Posts: n/a
Default "Too few data fields" error during .csv mail merge

I've downloaded a excel .csv data file that's filled with data of about
180 people, it's used to make a directory.

When I select it as my data source so that I can merge it with my form
document, Word pops up with the "Record ### contained too few data
fields." error message for several consecutive ranges of records (e.g.,
13-24, 60-78, 180-192).

I've done some reading up and testing and it seems to be caused by blank
fields in some records. When I pinpointed exactly which records and
fields were causing the problem, and put a "." or something in place of
the blank everything worked fine... except that I had a "." to deal with
then.

The worst of it is that I have many spots where there are blanks in the
data source, yet only a select few of them cause this problem, where
some of the blanks Word doesn't seem to have any problems with. As far
as I can tell there is NOTHING different between the blanks that cause
these error messages to come up and the other blanks (which are the
majority) that don't cause any problems. I've even tried copying one
blank cell and pasting it into the other bad blank cells but that
doesn't do anything.

Please tell me how I can slap this insolent excel file into shape so
that it can be used. I've actually used it before but have never
encountered this problem.

I'm using Excel and Word 2002.
  #2  
Old November 10th, 2004, 08:11 PM
Chris Singer
external usenet poster
 
Posts: n/a
Default

Oh man, I just saved the excel document as a regular 1 sheet workbook
and that worked perfectly. I don't even remember my reasoning for
keeping it as a .csv file, but I now curse the file format!
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I mail merge excel data to printable labels for envelop Judy Mailmerge 1 September 24th, 2004 10:01 AM
Word 2000/2002 - Proper Mail Merge steps for ODBC? Tony_VBACoder Mailmerge 7 September 2nd, 2004 09:21 PM
Word Mail Merge with SQL Data - URGENT !! Nitin Rana Mailmerge 1 August 21st, 2004 12:12 PM
Not enough fields in Excel for mail merge document Dave Mailmerge 2 June 8th, 2004 04:28 PM
Mail Merge two fields that have multiple lines with new line control code Eric Li Mailmerge 7 May 25th, 2004 06:10 PM


All times are GMT +1. The time now is 01:29 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.