Word unable to open data scource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kenb - 30 Sep 2006 13:28 GMT

I cannot complete a "mailmerge" The document is in "Word" and the (new) data
scource is "Excel" I keep getting the message " Word unable to open data
scource"

Reply to this Message

Peter Jamieson - 30 Sep 2006 16:11 GMT

Which version of Word/Excel?

Have you saved and closed your Excel workbook?

Does your Excel Workbook have one sheet, or more than one sheet?

How is your data laid out in Excel? You should have a table of data where
the first row contains a heading for each column.

Peter Jamieson

>I cannot complete a "mailmerge" The document is in "Word" and the (new)
>data
> scource is "Excel" I keep getting the message " Word unable to open data
> scource"

Reply to this Message

Kenb - 30 Sep 2006 17:04 GMT

Hi
Thanks for answering my question re Mail merge.

I am using Microsoft XP and my data is in Excel (columns headed c-name, s
name, add1, add2, add3, add4.

I have done this many times before successfully ~~ and some times not when
I have a new list of names (saved & closed) and I try to mail merge I get the
message "Word unable to open data source"

I have gone around a long way to correct this problem ~~ by opening a
previous list which I know works ~ saving it by another name ~ then closing
it, then I open the file that works delete all data, open the new data file
(that won't work) copy the data and paste onto the blank file.

Then I can complete the Mail merge successfully. ~~ BUT WHY ALL THE HARD
WORK???

John

> Which version of Word/Excel?
>
[quoted text clipped - 11 lines]
> > scource is "Excel" I keep getting the message " Word unable to open data
> > scource"

Reply to this Message

Rate this thread: