A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Unable to open data source" in mail merge



 
 
Thread Tools Display Modes
  #1  
Old March 3rd, 2009, 06:47 PM posted to microsoft.public.word.mailmerge.fields
Steve
external usenet poster
 
Posts: 2,662
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  
Old March 3rd, 2009, 07:32 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
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  
Old March 4th, 2009, 03:03 PM posted to microsoft.public.word.mailmerge.fields
Steve
external usenet poster
 
Posts: 2,662
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  
Old March 4th, 2009, 06:12 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
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  
Old March 4th, 2009, 06:48 PM posted to microsoft.public.word.mailmerge.fields
Steve
external usenet poster
 
Posts: 2,662
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  
Old March 4th, 2009, 06:51 PM posted to microsoft.public.word.mailmerge.fields
Steve
external usenet poster
 
Posts: 2,662
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  
Old March 4th, 2009, 08:31 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
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

  #8  
Old March 5th, 2009, 02:45 AM posted to microsoft.public.word.mailmerge.fields
Steve
external usenet poster
 
Posts: 2,662
Default "Unable to open data source" in mail merge

It may have been a or b. I restored the system to 3 days earlier and it works.
When this happened, I was successful merging, then immeditately therafter,
it stopped merging: "unable to open" stsrted.
How can this happen!????

"Peter Jamieson" wrote:

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


  #9  
Old March 5th, 2009, 08:06 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default "Unable to open data source" in mail merge

Much as I'd like to be able to explain "what went wrong" when things do
not work, it's usually difficult to do much more than make a few
guesses, unless I happen to be sitting there looking at the set-up
myself. Mostly, getting to a state where the thing works again is the
best that can be managed.

Some possibilities:
a. you have automatic updates installed and Windows has updated
something (not sure anything in Office 97 would be updated now)
b. something was corrupted and restoring the system put it back.

But...

Are you saying it started working again after the restore and it still
works, or it started working again and it has now stopped working again?

Peter Jamieson

http://tips.pjmsn.me.uk

STEVE wrote:
It may have been a or b. I restored the system to 3 days earlier and it works.
When this happened, I was successful merging, then immeditately therafter,
it stopped merging: "unable to open" stsrted.
How can this happen!????

"Peter Jamieson" wrote:

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:42 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.