[Jeff Kerry]

I have been able to merge an Excel data into mail merge in the past without a
problem.
Today when I try, I keep getting Word unable to open the data.

My Excel sheet has a numer of worksheets. I can not even pick the worksheet
now.

Can anyone offer any suggestions.

Tks,
Jeff

[Rodney]

With your Mail Merge toolbar showing, have you tried to click on the "Open
Data Source" button?
--
Rodney


"Jeff Kerry" wrote:

I have been able to merge an Excel data into mail merge in the past without a
problem.
Today when I try, I keep getting Word unable to open the data.

My Excel sheet has a numer of worksheets. I can not even pick the worksheet
now.

Can anyone offer any suggestions.

Tks,
Jeff

[Jeff Kerry]

Rodney,

Thank you for the reply. I just tried that option also and when the slect
tabel come up, it is all blank. SoI have not where to select from.

Jeff

"Rodney" wrote:

With your Mail Merge toolbar showing, have you tried to click on the "Open
Data Source" button?
--
Rodney


"Jeff Kerry" wrote:

I have been able to merge an Excel data into mail merge in the past without a
problem.
Today when I try, I keep getting Word unable to open the data.

My Excel sheet has a numer of worksheets. I can not even pick the worksheet
now.

Can anyone offer any suggestions.

Tks,
Jeff

[Peter Jamieson]

Which version of Word?

In the dialog box you see with a blan klist of sheets, do you see an
"Options" button? If so,
a. click it and check all the 4 boxes in the dialog that appears.
b. the list of sheets should then appear
c. it suggests to me that you are using Word 2002 or 2003, in which case
- previously Word would have opened the sheet using its default method
(called "OLEDB")
- something has gone wrong that prevents that method from opening the
workbook
- the workbook may have been corrupted.

If (c) is correct then I think your best option is probably to reconstruct
your workbook. That may or may not be straightforward depending on how
complex it is, but if the /only/ complexity is that it is multi-sheet and it
would be easy to recreate any formulas etc., then you could
a. export each sheet into a separate .csv file
b. import each .csv file into a workbook (you may be able to import into
new sheets, or you may need to import each one into a new workbook and
copy/paste into a new sheet)

However, if you decide to try to reconstruct your workbook, I would have a
look around at Excel-oriented resources (e.g. an Excel-oriented group) to
see if there are well-known approaches/tools for recovering workbooks.

I suppose it is also possible that you have exceeded some limit in Excel
that I'm not aware of, e.g. if you have more than x sheets, perhaps the
OLEDB provider gives up. Does that ring any bells?

Peter Jamieson
Jeff wrote in message
...
I have been able to merge an Excel data into mail merge in the past without
a
problem.
Today when I try, I keep getting Word unable to open the data.

My Excel sheet has a numer of worksheets. I can not even pick the
worksheet
now.

Can anyone offer any suggestions.

Tks,
Jeff

[Jeff Kerry]

Thank you for the reply.

I have started last night in re-constructing the file. That seems to be
doing the job for no.

I have not formulas or stuff lik that. The whole file is a list of names
and address. Then different column titles. In each column is just various
letters showing what they have requested.

Will let you know the final outcome.

Jeff

"Peter Jamieson" wrote:

Which version of Word?

In the dialog box you see with a blan klist of sheets, do you see an
"Options" button? If so,
a. click it and check all the 4 boxes in the dialog that appears.
b. the list of sheets should then appear
c. it suggests to me that you are using Word 2002 or 2003, in which case
- previously Word would have opened the sheet using its default method
(called "OLEDB")
- something has gone wrong that prevents that method from opening the
workbook
- the workbook may have been corrupted.

If (c) is correct then I think your best option is probably to reconstruct
your workbook. That may or may not be straightforward depending on how
complex it is, but if the /only/ complexity is that it is multi-sheet and it
would be easy to recreate any formulas etc., then you could
a. export each sheet into a separate .csv file
b. import each .csv file into a workbook (you may be able to import into
new sheets, or you may need to import each one into a new workbook and
copy/paste into a new sheet)

However, if you decide to try to reconstruct your workbook, I would have a
look around at Excel-oriented resources (e.g. an Excel-oriented group) to
see if there are well-known approaches/tools for recovering workbooks.

I suppose it is also possible that you have exceeded some limit in Excel
that I'm not aware of, e.g. if you have more than x sheets, perhaps the
OLEDB provider gives up. Does that ring any bells?

Peter Jamieson
Jeff wrote in message
...
I have been able to merge an Excel data into mail merge in the past without
a
problem.
Today when I try, I keep getting Word unable to open the data.

My Excel sheet has a numer of worksheets. I can not even pick the
worksheet
now.

Can anyone offer any suggestions.

Tks,
Jeff

[Rodney]

I assume you did try to select the data by clicking the "Open Data Source"
button, right?

The fact that you made reference to the Tables dialog box makes me wonder if
there is a problem in your SQL statement.

You may try running the following from a Module (Macro) and posting the
SQL statement here.

Sub FindSQL()
Dim qstring As String
qstring = ActiveDocument.MailMerge.DataSource.QueryString
MsgBox qstring
End Sub

It also may be helpful if you recorded a macro of trying to open the data
source and post it here.
--
Rodney


"Jeff Kerry" wrote:

Thank you for the reply.

I have started last night in re-constructing the file. That seems to be
doing the job for no.

I have not formulas or stuff lik that. The whole file is a list of names
and address. Then different column titles. In each column is just various
letters showing what they have requested.

Will let you know the final outcome.

Jeff

"Peter Jamieson" wrote:

Which version of Word?

In the dialog box you see with a blan klist of sheets, do you see an
"Options" button? If so,
a. click it and check all the 4 boxes in the dialog that appears.
b. the list of sheets should then appear
c. it suggests to me that you are using Word 2002 or 2003, in which case
- previously Word would have opened the sheet using its default method
(called "OLEDB")
- something has gone wrong that prevents that method from opening the
workbook
- the workbook may have been corrupted.

If (c) is correct then I think your best option is probably to reconstruct
your workbook. That may or may not be straightforward depending on how
complex it is, but if the /only/ complexity is that it is multi-sheet and it
would be easy to recreate any formulas etc., then you could
a. export each sheet into a separate .csv file
b. import each .csv file into a workbook (you may be able to import into
new sheets, or you may need to import each one into a new workbook and
copy/paste into a new sheet)

However, if you decide to try to reconstruct your workbook, I would have a
look around at Excel-oriented resources (e.g. an Excel-oriented group) to
see if there are well-known approaches/tools for recovering workbooks.

I suppose it is also possible that you have exceeded some limit in Excel
that I'm not aware of, e.g. if you have more than x sheets, perhaps the
OLEDB provider gives up. Does that ring any bells?

Peter Jamieson
Jeff wrote in message
...
I have been able to merge an Excel data into mail merge in the past without
a
problem.
Today when I try, I keep getting Word unable to open the data.

My Excel sheet has a numer of worksheets. I can not even pick the
worksheet
now.

Can anyone offer any suggestions.

Tks,
Jeff

[Rodney]

One other thing I meant to mention. You didn't say what version of Word you
were using. The article at http://support.microsoft.com/kb/289830 may apply
to you.
--
Rodney


"Rodney" wrote:

I assume you did try to select the data by clicking the "Open Data Source"
button, right?

The fact that you made reference to the Tables dialog box makes me wonder if
there is a problem in your SQL statement.

You may try running the following from a Module (Macro) and posting the
SQL statement here.

Sub FindSQL()
Dim qstring As String
qstring = ActiveDocument.MailMerge.DataSource.QueryString
MsgBox qstring
End Sub

It also may be helpful if you recorded a macro of trying to open the data
source and post it here.
--
Rodney


"Jeff Kerry" wrote:

Thank you for the reply.

I have started last night in re-constructing the file. That seems to be
doing the job for no.

I have not formulas or stuff lik that. The whole file is a list of names
and address. Then different column titles. In each column is just various
letters showing what they have requested.

Will let you know the final outcome.

Jeff

"Peter Jamieson" wrote:

Which version of Word?

In the dialog box you see with a blan klist of sheets, do you see an
"Options" button? If so,
a. click it and check all the 4 boxes in the dialog that appears.
b. the list of sheets should then appear
c. it suggests to me that you are using Word 2002 or 2003, in which case
- previously Word would have opened the sheet using its default method
(called "OLEDB")
- something has gone wrong that prevents that method from opening the
workbook
- the workbook may have been corrupted.

If (c) is correct then I think your best option is probably to reconstruct
your workbook. That may or may not be straightforward depending on how
complex it is, but if the /only/ complexity is that it is multi-sheet and it
would be easy to recreate any formulas etc., then you could
a. export each sheet into a separate .csv file
b. import each .csv file into a workbook (you may be able to import into
new sheets, or you may need to import each one into a new workbook and
copy/paste into a new sheet)

However, if you decide to try to reconstruct your workbook, I would have a
look around at Excel-oriented resources (e.g. an Excel-oriented group) to
see if there are well-known approaches/tools for recovering workbooks.

I suppose it is also possible that you have exceeded some limit in Excel
that I'm not aware of, e.g. if you have more than x sheets, perhaps the
OLEDB provider gives up. Does that ring any bells?

Peter Jamieson
Jeff wrote in message
...
I have been able to merge an Excel data into mail merge in the past without
a
problem.
Today when I try, I keep getting Word unable to open the data.

My Excel sheet has a numer of worksheets. I can not even pick the
worksheet
now.

Can anyone offer any suggestions.

Tks,
Jeff