View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
 
Posts: n/a
Default Unable to re-establish a DDE connection

I have search the net and tried the "solutions" from Microsoft. No
luck. Here is the situation.

I use Office 2000. I had a form letter and an envelope generator with
an Access table and it has worked fine for a couple of months. Just
today the records in the Access table seemed to get out of order. I
created a query sorting by a date field and then inserted a number
field. I select based upon the number field.

Well, now I cannot establish a DDE connection to Microsoft Access.
There are no quotes in the table name. I am not selecting on an image.
Everything is as it was.

To test this (after a couple of reboots), I created a minimal Access
table (two fields, one entry). I then tried with a new word document
to do a merge. No luck there either. It seems that there is something
drastically wrong in the Access-Word connection.

As a temporary work-around, I selected all the records from the table
and pasted them into an Excel spreadsheet and changed the datasource in
the letter and envelope to this Excel document. That works fine.

Can someone tell me how to fix the basic problem?

Shelly