Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Word Mail Merge Error 5922 Problem

Posted on 2003-03-13
9
Medium Priority
?
1,067 Views
Last Modified: 2007-12-19
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>|etc... <CR>
<data1>|<data2>|<data3>|etc... <CR>

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?
0
Comment
Question by:kevin03
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 23

Accepted Solution

by:
slink9 earned 300 total points
ID: 8127029
0
 

Author Comment

by:kevin03
ID: 8159410
The problem appears to be resolved by:

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.
0
 
LVL 11

Expert Comment

by:turn123
ID: 10112145
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
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 23

Expert Comment

by:slink9
ID: 10113144
Agreed.
0
 

Author Comment

by:kevin03
ID: 10172580
Close this question
0
 
LVL 11

Expert Comment

by:turn123
ID: 10172859
kevin03,

SpazMODic closed it by forcing the except of slink9's answer.  Is that what your asking?

Turn123
0
 

Author Comment

by:kevin03
ID: 10173179
Just confirming that this question has been answered and can be closed.

thanks
0
 
LVL 1

Expert Comment

by:keimpe
ID: 21911848
I just solved this 5922 problem by removing a " (double quote) that someone accidentally put in one of the text fields.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In today’s time where quality is an essential factor all over the world, software testing and effective QA (Quality Assurance) is an all-important element for any business to ensure less risk for an end product. A good software testing company deliv…
There are literally thousands of Exchange recovery applications out there. So how do you end up picking one that’s ideal for your business & purpose? By carefully scouting the product’s features, the benefits it offers you, & reading ample reviews f…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question