 |
 | 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 / February 2004Mail merge with one record
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, 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? > Thanks, > JP No, my one record datafile does not have a header row. JP >-----Original Message----- >Hi JP, [quoted text clipped - 29 lines] > >. 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 > No, my one record datafile does not have a header row. > [quoted text clipped - 45 lines] > > > >. 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 ------------------------------------------------ |
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.