?
Solved

Word Mail Merge Error 5922 Problem

Posted on 2003-03-13
9
Medium Priority
?
1,060 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
9 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
Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

 
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
Suggested Courses

770 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