[flintmj]

My company does utility billing. We generate over 30,000 bills a month. We have a set way of doing things, and I am having a problem. Until recently we used office 2000 to create our mail merge bills. Everything was smooth. We upgraded to 2003, and I have been troubleshooting issues ever since. We get our data from Lotus 9 spreadsheets. That data is currently saved as a .CSV file and then sorted from there. We then merge our .CSV file into a Word doc (bill form). The problem is sometimes we get errors like "Record "so and so" has too many/few data fields". I know what is causing this, empty rows or columns in the .CSV file. These can not be avoided. Is there a way to edit the registry to eliminate these messages, they are time consuming when printing. Or do you know of another fix? Thank you for your time.

[jimr381]

Welcome to the forum.

Within MS Word. I would just search for the double return which is what will be displaying the space in-between the rows and replace it with a single return.