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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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
|
|||
|
|||
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 | |
|
|
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 |