View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
amalthea
 
Posts: n/a
Default problem merging from microsoft excel

I am having a problem with the mail merge program in word. My computer
runs on MS office xp. I have a created mail merge document in Word
with its data source being from excel. I used it multible times.
Recently, when I try to open my mail merge document, it tells me my
document "is a mail merge main document. Word cannot find its data
source," which is in excel. I click on "find Data Source". I find
the excel file and click ok. This will then bring me to a window that
says to "select table", but no tables are avalible. The excel sheet
has 3 named tables in it, but none appear. I would like to be able to
reconnect my documents with the excel sheets.

I have also tried to "type a new list" with the mail merger wizard in
word. It gives me the error message of "Operation can not be completed
because of dialog or database engine failures. Please try again
later." When I try later, it still does not work.

I thought these two might be connected, but I am not sure. Anybody
have any ideas on how to fix this problem?

Thank you in advance,
Amy