 |
 | 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 / March 2006record 16 contained too few data fields error on word 2003 from cs
I download data from paypal to a csv file. I then have a standard word document to create address labels. When I use the merge facility, if the CSV file is more than 16 lines long i get the error message: "Record 16 contained too few data fields" I then hit the ok button and I get the same message for record 17 and so on, until it hits the end of the file, but the records have all merged perfectly. I know it is not a problem with the data, because if for example I take record 1 from same file (which didnt error) and repeat it 17 times, as soon as I hit record 16 the error starts again. There is obviously a problem with mail merge but is there a fix??? I can obviously get round it by hitting enter until it gets to end of file but if you have hundreds of records its a knightmare. It only seems to happen with CSV files I don't know if this is a similar problem, that happens when you try to import a *.CSV file or Database list into the Outlook Express Address Book. If you create the *.CSV file, using anything other than the OE AB wizard. You will need to add an extra comma (,) to each line. You can easily do this by adding an extra blank column/field at the end, in your database or spreadsheet program.  SignatureHave A Good Day Rich/rerat Add MS to your News Reader: news://msnews.microsoft.com (RRR News) <message rule> <<Previous Text Snipped to Save Bandwidth When Appropriate>> I download data from paypal to a csv file. I then have a standard word document to create address labels. When I use the merge facility, if the CSV file is more than 16 lines long i get the error message: "Record 16 contained too few data fields" I then hit the ok button and I get the same message for record 17 and so on, until it hits the end of the file, but the records have all merged perfectly. I know it is not a problem with the data, because if for example I take record 1 from same file (which didnt error) and repeat it 17 times, as soon as I hit record 16 the error starts again. There is obviously a problem with mail merge but is there a fix??? I can obviously get round it by hitting enter until it gets to end of file but if you have hundreds of records its a knightmare. It only seems to happen with CSV files mmm, what a pain! looks like that is the problem. I wanted a really automated process so it now means going to have to manually alter the file every time to correct, the lines that dont have the commas at the end. Weird its always from line 16 onwards though. Might have to chat to paypal and see if they know why their download program doesnt put a comma from that point onwards Thanks Dean > I don't know if this is a similar problem, that happens when you try to import a > *.CSV file or Database list into the Outlook Express Address Book. If you create [quoted text clipped - 21 lines] > > It only seems to happen with CSV files You could always convert the CSV file to a Word table - see http://www.gmayor.com/convert_labels_into_mail_merge.htm Word is much happier with tables ;) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > mmm, what a pain! > looks like that is the problem. [quoted text clipped - 48 lines] >> >> It only seems to happen with CSV files |
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.