When I MailMerge Excel into Word...

[Guest]

I get an error: "can't open data source".
I have Office 97, did the SR2 update.
Any suggestions please?

 

[Peter Jamieson]

Has this just stopped working?

If so, can you go back to a previous version of your Excel sheet?

If not, can you experiment by creating a very simple Excel spreadsheet (say,
with 2 columns, one row containing headers and two rows of data) and using
that as the data source for a merge? If you can get that to work, it
suggests that there may be something wrong with your Excel sheet: if it is
simple enough to export as .csv format and re-import into a new sheet, try
that. Otherwise you may have to recreate the sheet from scratch or fiind
another way to merge the data.

 

[Guest]

Hey Peter,
How do I get to a previous version?
(I will do test you suggest)
Thanks for responding

 

[Guest]

Word and Excel are both 97.
This started after hard drive crashed. Got a new one, loaded Office 97 CD,
updates.
Word and Excel docs are from a backup made with same Office 97.

 

[Peter Jamieson]

How do I get to a previous version?

Only possible if you had a backup, which does not appear to be the case!

 

[Guest]

This is the first time I am trying to do a mailmerge since the Hard drive
crashed. Reinstalled Office 97. Restored backup documents that were created
w/ 97.
(however, I updated excel to a more current version)

 

[Peter Jamieson]

SO what happened when you did the experiment?

 

[Guest]

Got the same error message.

SO what happened when you did the experiment?

 

[Guest]

Now, suddenly, I can't open an Excel document.
I says: "Windows can't find it"

 

[Guest]

Peter,
Also put data into a new worksheet......Windows can't find it either.
I can, however still open it when clicking on file, open.
But when I click on the doc to open it, Windows can't find it.

 

[Suzanne S. Barnhill]

In Excel, go to Tools | Options | General and make sure that "Ignore other
applications" is not checked.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

Thanks, that allows for me to open docs.
Now, how about my main problem: "Unable to open source"

 

[Suzanne S. Barnhill]

Try reconnecting to the source using the Open Data Source button on the Mail
Merge toolbar. Occasionally Word loses track of it.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.