Mail merge with one record

[JP]

Hi,

In Word 2000 I have a mail merge document and a merge.txt datasource as the merge file with multiple records and fields delimted by commas like: "Field1", "Field2","Fields". Example:

"John Doe", "1 Main Street", "Boston", "MA", "02222"
"John Doe", "1 Main Street", "Boston", "MA", "02222"
"John Doe", "1 Main Street", "Boston", "MA", "02222"

My question is: When I have more than one record in the merge file the word document automatically recognizes that the field delimiter is the comma. If I have only one record in the file it always prompts me to select the correct delimiter for the file? Why is this? Is it a bug? I have tried extra Carriage Returns in the file that has only one record with no luck. Is there anything you can suggest I try when there is only one record in the .txt datasource merge file to get it to recognize the delimter?

Thanks,
JP

 

[Doug Robbins - Word MVP]

Hi JP,

Does your one record datafile have a header row?

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

Hi,

In Word 2000 I have a mail merge document and a merge.txt datasource as

the merge file with multiple records and fields delimted by commas like:
"Field1", "Field2","Fields". Example:

"John Doe", "1 Main Street", "Boston", "MA", "02222"
"John Doe", "1 Main Street", "Boston", "MA", "02222"
"John Doe", "1 Main Street", "Boston", "MA", "02222"

My question is: When I have more than one record in the merge file the

word document automatically recognizes that the field delimiter is the
comma. If I have only one record in the file it always prompts me to select
the correct delimiter for the file? Why is this? Is it a bug? I have
tried extra Carriage Returns in the file that has only one record with no
luck. Is there anything you can suggest I try when there is only one record
in the .txt datasource merge file to get it to recognize the delimter?

 

[JPem]

No, my one record datafile does not have a header row.

JP

 

[Doug Robbins - Word MVP]

Hi JPem,

I would guess that then is the problem.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Latha]

Even with header record MSword 2000 is displaying the Header record
delimiter dialogue. Is there any way of getting rid of that. My
datafile is seperated by "|". It recognises the delimiter if I have
more than 8 records.

Thanks in advance