[Sam]

Hi there!
I just wanted to set up labels for a mail merge and when I browse for the
database, for some reason I cannot use my database (excel). I can choose the
file, select the table but then again another "select table" window opens
where I cannot choose any table (empty) or no matter which workbook I choose,
it always says "word was unable to open the data source".

Any suggestions? I used the same format yesterday with a different excel
file and everything was fine.

Thanks a lot,
Sam

[Yvonnej]

Sam,

Not sure if this will help, but when merging from Excel make sure you only
have the column headings and then the data with nothing above the column
headings.

Hope this is helpful for you
--
YvonneJ


"Sam" wrote:

Hi there!
I just wanted to set up labels for a mail merge and when I browse for the
database, for some reason I cannot use my database (excel). I can choose the
file, select the table but then again another "select table" window opens
where I cannot choose any table (empty) or no matter which workbook I choose,
it always says "word was unable to open the data source".

Any suggestions? I used the same format yesterday with a different excel
file and everything was fine.

Thanks a lot,
Sam

[Sam]

Thanks, Yvonnej! But this is not it. I do not have anything above the normal
headings... ;-(

Any other idea??

Thanks again,
Sam

"Yvonnej" wrote:

Sam,

Not sure if this will help, but when merging from Excel make sure you only
have the column headings and then the data with nothing above the column
headings.

Hope this is helpful for you
--
YvonneJ


"Sam" wrote:

Hi there!
I just wanted to set up labels for a mail merge and when I browse for the
database, for some reason I cannot use my database (excel). I can choose the
file, select the table but then again another "select table" window opens
where I cannot choose any table (empty) or no matter which workbook I choose,
it always says "word was unable to open the data source".

Any suggestions? I used the same format yesterday with a different excel
file and everything was fine.

Thanks a lot,
Sam

[swanskerry]

A user here had that same problem pop up last week. We created a named
range in the Excel file containing the header row and merge data and
selected that in the Select Table window. Worked perfectly. One thing
to look for though - the very top left cell in her spreadsheet was
blank, which often occurs with tables because the left column and top
row are used for data labels. Make sure it's not blank in your
spreadsheet. HTH


Sam wrote:
Thanks, Yvonnej! But this is not it. I do not have anything above the normal
headings... ;-(

Any other idea??

Thanks again,
Sam

"Yvonnej" wrote:

Sam,

Not sure if this will help, but when merging from Excel make sure you only
have the column headings and then the data with nothing above the column
headings.

Hope this is helpful for you
--
YvonneJ


"Sam" wrote:

Hi there!
I just wanted to set up labels for a mail merge and when I browse for the
database, for some reason I cannot use my database (excel). I can choose the
file, select the table but then again another "select table" window opens
where I cannot choose any table (empty) or no matter which workbook I choose,
it always says "word was unable to open the data source".

Any suggestions? I used the same format yesterday with a different excel
file and everything was fine.

Thanks a lot,
Sam

[Cindy M.]

Hi Sam,

I just wanted to set up labels for a mail merge and when I browse for the
database, for some reason I cannot use my database (excel). I can choose the
file, select the table but then again another "select table" window opens
where I cannot choose any table (empty) or no matter which workbook I choose,
it always says "word was unable to open the data source".

Any suggestions? I used the same format yesterday with a different excel
file and everything was fine.

I'm having difficulties making sense of the circumstances - although the error
message is clear enough :-)

Which version of Word are we dealing with, here? I'm guessing 2002 or 2003?

Is the table you want to use not on the first sheet in the Workbook? Does it not
start in cell A1? And have you not applied a Name to the table range?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)