Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Steve Steve is offline
external usenet poster
 
Posts: 298
Default "Unable to open data source" in mail merge

This just started, and it was just successful in opening data.
Word 97.
Please help
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default "Unable to open data source" in mail merge

What is the data source? Where is it?

Peter Jamieson

http://tips.pjmsn.me.uk

STEVE wrote:
This just started, and it was just successful in opening data.
Word 97.
Please help

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Steve Steve is offline
external usenet poster
 
Posts: 298
Default "Unable to open data source" in mail merge

It is an excel cvs extension on my hardrive

"Peter Jamieson" wrote:

What is the data source? Where is it?

Peter Jamieson

http://tips.pjmsn.me.uk

STEVE wrote:
This just started, and it was just successful in opening data.
Word 97.
Please help


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default "Unable to open data source" in mail merge

Do you mean a .csv, which is a delimited text file that you can open in,
and save from, Excel?

If so, can you open it in (say) Notepad and verify that it really is a
plain text file delimited by commas?

Peter Jamieson

http://tips.pjmsn.me.uk

STEVE wrote:
It is an excel cvs extension on my hardrive

"Peter Jamieson" wrote:

What is the data source? Where is it?

Peter Jamieson

http://tips.pjmsn.me.uk

STEVE wrote:
This just started, and it was just successful in opening data.
Word 97.
Please help

  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Steve Steve is offline
external usenet poster
 
Posts: 298
Default "Unable to open data source" in mail merge

It is, now what?
It's doing this even on old mail-merge files that use to work.

"Peter Jamieson" wrote:

Do you mean a .csv, which is a delimited text file that you can open in,
and save from, Excel?

If so, can you open it in (say) Notepad and verify that it really is a
plain text file delimited by commas?

Peter Jamieson

http://tips.pjmsn.me.uk

STEVE wrote:
It is an excel cvs extension on my hardrive

"Peter Jamieson" wrote:

What is the data source? Where is it?

Peter Jamieson

http://tips.pjmsn.me.uk

STEVE wrote:
This just started, and it was just successful in opening data.
Word 97.
Please help




  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Steve Steve is offline
external usenet poster
 
Posts: 298
Default "Unable to open data source" in mail merge

Yes, I do. now what?

"Peter Jamieson" wrote:

Do you mean a .csv, which is a delimited text file that you can open in,
and save from, Excel?

If so, can you open it in (say) Notepad and verify that it really is a
plain text file delimited by commas?

Peter Jamieson

http://tips.pjmsn.me.uk

STEVE wrote:
It is an excel cvs extension on my hardrive

"Peter Jamieson" wrote:

What is the data source? Where is it?

Peter Jamieson

http://tips.pjmsn.me.uk

STEVE wrote:
This just started, and it was just successful in opening data.
Word 97.
Please help


  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default "Unable to open data source" in mail merge

There are three main possibilities, e.g.
a. something has changed in Word/Windows that prevent Word from
opening your file
b. something has changed about the content or structure of your file
that prevents Word from opening it.
c. the Word Mail Merge Main document has been corrupted in some way
and that is the cuse of the problem.

You can test (c) by creating a completely new mail merge main document
and trying to connect to the same data source.

Otherwise, I would start by guessing that it is (b) and try to test that
theory. For example, if you save the current version of your file, then
perhaps if you have a backup of an earlier version saved somewhere you
could try using that as the data source. Or if you don't have an old
version, you could consider constructing a test version with only a few
rows and see if that works OK. If it does, then (b) looks pretty likely
and it becomes a question of working out what has changed. If older test
data doesn't work either, then (a) looks more likely.


Peter Jamieson

http://tips.pjmsn.me.uk

STEVE wrote:
Yes, I do. now what?

"Peter Jamieson" wrote:

Do you mean a .csv, which is a delimited text file that you can open in,
and save from, Excel?

If so, can you open it in (say) Notepad and verify that it really is a
plain text file delimited by commas?

Peter Jamieson

http://tips.pjmsn.me.uk

STEVE wrote:
It is an excel cvs extension on my hardrive

"Peter Jamieson" wrote:

What is the data source? Where is it?

Peter Jamieson

http://tips.pjmsn.me.uk

STEVE wrote:
This just started, and it was just successful in opening data.
Word 97.
Please help

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2007 - "word was unable to open the data source" Tom Koski Mailmerge 5 August 6th 08 08:52 PM
Word mail merge "Unable to Obtain List of Tables from Data Source" Stephen Ford Mailmerge 10 February 11th 08 07:42 AM
Excel merge into Word:"unable to open data source" STEVE Microsoft Word Help 3 September 21st 07 02:58 PM
reversing "Last, first" in mail merge from one data source field Plum3pc Mailmerge 2 August 27th 06 06:51 AM
trouble with mail merge, word was unable to open data source edie Mailmerge 2 May 10th 06 04:46 PM


All times are GMT +1. The time now is 01:58 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"