Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Word 2000 Mail Merge Headers

Posted on 2001-09-06
14
Medium Priority
?
250 Views
Last Modified: 2006-11-17
I have two machines with Word 2000 and I'm having a problem on one when trying to use mail merge with a Tab Delimited TXT file as the data source.

My Data is:
Name (tab) Address (tab) City
John (tab) Elm St. (tab) MyTown

Problem is, when I create document, open data source (no separate header file) and then click "Insert Merge Field"

I see....
Name_Address_City

Instead of the expected...
Name
Address
City

This works on one machine but not the other.  If I save the TXT file as a DOC file and then use it as a data source it works correctly.

Is there an optional setting for delimiters in the header record of a TXT Merge File???  Or, what's happening??
0
Comment
Question by:trims30
[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
  • 8
  • 4
  • 2
14 Comments
 

Expert Comment

by:KBMacKenzie
ID: 6462303
Hi, trims30.  I am unable to duplicate your issue.  I've checked 4 different machines in my area, and all behave in the expected manner.

Therefore, I would begin suspecting either (a) corrupt normal.dot; (b) corrupt style in the main document; or (c) other unknown issues.

On the machine where the problem is being exhibited, can you close Word and rename normal.dot to normal.old, restart Word and see if the behavior continues.  If that doesn't clear it up, then...

Use the wizard's Edit the main document option to restore to a normal word file.  Go to Format / Styles and start going one-by-one through the styles... if there are any displaying strange things (such as Asian letters), use organizer to copy the style from your new normal.dot to the document.  If that doesn't clear it up, then...

Click on Help / Detect and Repair.  Make sure you have your installation CD's with you.

HTH
0
 

Author Comment

by:trims30
ID: 6462351
KBMacKenzie:

Renamed all normal.dot files,
looked at styles and compared them to working machine
and even did the Detect/Repair!

Still same results!

Now I'm really stumped!

Lee
0
 

Accepted Solution

by:
KBMacKenzie earned 150 total points
ID: 6462516
Well, Lee -- this is a bit perplexing.

I've searched the MS Knowledge Base and came up with zip.

Are you using the identical data file on both machines?
Are they both running the same version of Word 2000 (such as one is SR1(a) and the other is SR2)?
Where was the text file created?

Maybe where it's messing up:
At the open file explorer window where you select the text file, mark the box that says Select Method (near the open button) -- this should give you another dialog that may be of use (play and be creative!)

I'm fresh out of ideas.  Please post if you come up with a solution.

Thanks.
Karen
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

Author Comment

by:trims30
ID: 6462716
Karen:
Same version of Office 2000 on both machines.  As a matter of fact, I found a third machine in the office that does exactly the same thing ie; A_B_C  for merge fields!

I'm puzzled too!

Thanks for your input,

Lee
0
 
LVL 44

Expert Comment

by:bruintje
ID: 6468203
Hi trims30,

Guess this has to do with the tab between teh names in your textfile, could you try to make a new textfile with just one row of data and put the tabs in by hand?

I'm not sure about this but from above it seems like word encounters a unicode problem with some sign and converts it to a _

:O)Bruintje
0
 
LVL 44

Expert Comment

by:bruintje
ID: 6468204
btw where does this file come from?
0
 

Author Comment

by:trims30
ID: 6468525
bruintje:

The Merge Data File in my example is created in Word and saved as Text File. If I save as a DOC file it will work correctly.

If I create the file in Notepad, WordPad, or Excel, I also get the same results when using tab delimited header row.

If I use commas rather than tabs it also works correctly.

Somehow word is interpreting TABS in the Header as Underscore characters....

Beleive it or not!
0
 

Author Comment

by:trims30
ID: 6468548
bruintje:

Another curiosity is that if I use MSQuery to open the Tab Delimited TEXT file (either via WORD or Excel-Get External Data) I have the same results  "A_B_C" as my single field name rather than:
A
B
C

Lee
0
 
LVL 44

Expert Comment

by:bruintje
ID: 6468595
funny i see this happening here also, the data is correctly displayed in a table in the document, but the header is being underscored.....
0
 

Author Comment

by:trims30
ID: 6468644
bruintje:
Glad you could duplicate the problem.

Now all we need is an answer as to why it happens.

Lee
0
 

Author Comment

by:trims30
ID: 6468906
Eureka!  I found the answer!


The ODBC Text driver can't convert tab-delimited text files.

There is a way to work around this problem:

Use a comma-delimited text file.

Specify the Text Files conversion method when attaching the data source.

To specify the Text Files conversion method
In the Mail Merge Helper, click Get Data, and then click Open Data Source.

Click your data source, select the Select method check box, and then click Open.

In the Confirm Data Source dialog box, click Text Files, and then click OK.

Important
If there is a Text Files via ODBC option, don't choose it. Click the Text Files option.


In all fairness, Karen MacKenzie had mentiond exactly that but offered no explanation..

"At the open file explorer window where you select the text file, mark the box that says Select Method
(near the open button) -- this should give you another dialog that may be of use (play and be creative!)"

0
 

Author Comment

by:trims30
ID: 6468907
Eureka!  I found the answer!


The ODBC Text driver can't convert tab-delimited text files.

There is a way to work around this problem:

Use a comma-delimited text file.

Specify the Text Files conversion method when attaching the data source.

To specify the Text Files conversion method
In the Mail Merge Helper, click Get Data, and then click Open Data Source.

Click your data source, select the Select method check box, and then click Open.

In the Confirm Data Source dialog box, click Text Files, and then click OK.

Important
If there is a Text Files via ODBC option, don't choose it. Click the Text Files option.


In all fairness, Karen MacKenzie had mentiond exactly that but offered no explanation..

"At the open file explorer window where you select the text file, mark the box that says Select Method
(near the open button) -- this should give you another dialog that may be of use (play and be creative!)"

0
 

Author Comment

by:trims30
ID: 6468919
Thanks to everyone for their help!

While Karens answer was not specific enough to rate an "A" I atleast gave it a "Good" rating.



At the open file explorer window where you select the text file, mark the box that says Select Method
(near the open button) -- this should give you another dialog that may be of use (play and be creative!)

By then selecting TEXT File , the tab delimited file opens correctly.
0
 
LVL 44

Expert Comment

by:bruintje
ID: 6468940
glad you found an answer :O)Bruintje
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

715 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