kevin03
asked on
Word Mail Merge Error 5922 Problem
I am using a single text file to mail merge data into a Word document. The mail merge process works fine on some installations of Word 97 running on Win NT 2000 but on other similiar Word installations I get the Error 5922.
I am using the | (pipe symbol) to delimiter my fields and I think Word is having problems recognising the demiliter.
My text file structure is:
<field1>|<field2>|<field3>
<data1>|<data2>|<data3>|et
For empty data fields I have tried inserting a space between delimiters but this still does not fix the problem.
When I change the delimiter to a comma in my text file the mail merge works fine. However I would like to use the | delimiter instead. Is there something in the installation's environment that I should be checking to make this work consistently?
I am using the | (pipe symbol) to delimiter my fields and I think Word is having problems recognising the demiliter.
My text file structure is:
<field1>|<field2>|<field3>
<data1>|<data2>|<data3>|et
For empty data fields I have tried inserting a space between delimiters but this still does not fix the problem.
When I change the delimiter to a comma in my text file the mail merge works fine. However I would like to use the | delimiter instead. Is there something in the installation's environment that I should be checking to make this work consistently?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
kevin03,
No comment has been added lately (302 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
RECOMMENDATION: Award points to slink9 http:#8127029
Please leave any comments here within 7 days.
-- Please DO NOT accept this comment as an answer ! --
Thanks,
turn123
EE Cleanup Volunteer
No comment has been added lately (302 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
RECOMMENDATION: Award points to slink9 http:#8127029
Please leave any comments here within 7 days.
-- Please DO NOT accept this comment as an answer ! --
Thanks,
turn123
EE Cleanup Volunteer
Agreed.
ASKER
Close this question
kevin03,
SpazMODic closed it by forcing the except of slink9's answer. Is that what your asking?
Turn123
SpazMODic closed it by forcing the except of slink9's answer. Is that what your asking?
Turn123
ASKER
Just confirming that this question has been answered and can be closed.
thanks
thanks
I just solved this 5922 problem by removing a " (double quote) that someone accidentally put in one of the text fields.
ASKER
1) Creating mail merge documents in Word97.
2) Saving your text data source file with a non text file extension such as .dat to force Word to use its own text convertor and not the ODBC text file driver.