Header Record Delimiter (comma does not work)

[Dan Meigs]

Office 2007 Word. Mail Merge. Select Recipients. Use Existing List. Select
Data Source. path.txt.

The comma selection does not work. When selected, the error message "Record
n contained too many data fields" .. appears

The .txt file is fine and works fine when imported as a text file into Excel.

Any fixes out there?

TIA

Dan

 

[Peter Jamieson]

1. Let's assume you do not have unquoted fields that contain commas.

2. if you create a coma-deleimited test file with (say) two columns, a
header row and two data rows, does that work?

3. Not sure the following make any difference, but...
a. which delimiter dialog are you seeing? Are you seeing the one that
asks for field and record delimiter, and shows a number of options for
each, or the (OLE DB) dialog that lets you choose a field delimiter
which can be comma, tab or other?
b. Is comma set to be the decimal point character in Regional
Settings on your system?

Peter Jamieson

http://tips.pjmsn.me.uk