Mail merge with Excel

[Bryan]

I recently ugraded to Windows XP and am having a problem connecting to my Excel database for a Word mail merge. Right after I upgraded, I had no problem and the program even remembered where the database was and found it when I opened the document. Life was great! Then suddenly it didn't find the file, so I did a "Find data source" and found it. But when I inserted the database file, I got a "select table" window. I'd never seen that before. There are no files to select showing, but there is a dropdown called "Work Book" that has all my databases; but when I select one of them, the OK button grays out. I am on a network if that makes any difference. Any help would be greatly appreciated.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?QnJ5YW4=?=,

I recently ugraded to Windows XP and am having a problem connecting to my Excel

database for a Word mail merge. Right after I upgraded, I had no problem and the
program even remembered where the database was and found it when I opened the
document. Life was great! Then suddenly it didn't find the file, so I did a "Find
data source" and found it. But when I inserted the database file, I got a "select
table" window. I'd never seen that before. There are no files to select showing,
but there is a dropdown called "Work Book" that has all my databases; but when I
select one of them, the OK button grays out. I am on a network if that makes any
difference.Which version of Word is involved, here? And has that changed recently?

Have you asked your network administrator if they've changed anything? Restricted
permissions in the locations where the Word or Excel files are stored, for
example?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
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

 

[Hilary]

I am having the same exact problem. We have not had any
changes on our network and all of my updates have been
installed.

Hilary