Results 1 to 14 of 14
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    London, Gtr London, England
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Trouble Opening Form Letter (2000 SP3)

    I am having difficulty opening a form letter with an Access Database as the data source. When I click on the .doc file everything hangs with the status bar reading "Waiting for MS Access to Accept DDE Commands".
    The letter was created about a year ago on an older machine so the paths of the Word file and the Access data will likely have changed but the file names haven't.
    Any ideas on how to open the .doc?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Trouble Opening Form Letter (2000 SP3)

    Have you tried specifying the data source anew? In step 2 of the Mail Merge Helper (Data source), click Get Data, then Open Data Source.

    If you have no luck with DDE, try MS Access Database via ODBC (*.mdb).

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    London, Gtr London, England
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble Opening Form Letter (2000 SP3)

    Thanks Hans

    I had thought of trying that but when I have the open file dialogue box and select the form letter and click open the DDE message appears, Word just hangs and can only be closed using the task manager when the thing offers to send a message to Microsoft.

    The database is Ok because in the short term I solved the immediate problem by creating a new form letter on a laptop using Word XP and it was happy to use the same data source despite being connected only over a wireless network!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Trouble Opening Form Letter (2000 SP3)

    It seems probable that the document is corrupt. If Word hangs the moment you try to open it, there's not much you can do with it.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    London, Gtr London, England
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble Opening Form Letter (2000 SP3)

    Hans

    Things seem worse than I thought. I have tried making a totally new, unrelated form letter and as soon as I try to associate any Access file as the data source I encounter exactly the same problem/error message.

    Do you thin a Word Repair might help?

    Regards

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble Opening Form Letter (2000 SP3)

    Hi Sue:
    I would try to repair, using the function from the Help menu. I would also use the steps listed in <post#=197827>post 197827</post#>. In the meantime, I'll see if I can find anything else on your error message.
    Hope this helps,

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Trouble Opening Form Letter (2000 SP3)

    Check if the DDE settings in Access are correct:

    Open any database in Access.
    Select Tools | Options...
    Activate the Advanced tab.
    The "Ignore DDE Requests" check box should be clear (off).
    The "Enable DDE Refresh" check box should be ticked (on).
    The "OLE/DDE Timeout (sec)" should be set to a reasonable interval (30 is the default value).

  8. #8
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    London, Gtr London, England
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble Opening Form Letter (2000 SP3)

    Hans & Phil

    Truckloads of virtual beers to you both. Goodness know what it was (although i suspect last months update to SP3) repairing Word enabled me to make new form letters with a .mdb as data source and to open all of my older ones.

    Many thanks

    Sue

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble Opening Form Letter (2000 SP3)

    Hi Sue:
    I couldn't find anything directly on point at the knowledge base. There is an article that says you can't use the Insert/Database command if your Access query or table has quotes in its name (here), but that doesn't sound like your problem. Perhaps when Hans gets back online, he'll have some more ideas.

  10. #10
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    London, Gtr London, England
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble Opening Form Letter (2000 SP3)

    Hans

    You are seriously the Speedy Gonzalez of this Board! Your post about enable DDE came in as I was replying to you and Phil - having done the repair the settings are as you recommend (and I suspect the defaults). I was so fazed this afternoon that I am saving the whole of this thread to my hard drive.

    Next time you are in London those virtual beers can be cashed in!

    Thanks a million

  11. #11
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    London, Gtr London, England
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble Opening Form Letter (2000 SP3)

    Phil

    Sorry but you are as quick as Hans and so much better than me. The conversion of vitual beers to real ones goes for you too if you ever get to London.

    Sue

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Trouble Opening Form Letter (2000 SP3)

    I'm glad you got it solved. This kind of problem can be difficult to get a finger behind.

    I'll have a virtual <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>, thanks.

  13. #13
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    London, Gtr London, England
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble Opening Form Letter (2000 SP3)

    Enjoy - but I am serious about the real one!

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Trouble Opening Form Letter (2000 SP3)

    If I come to England to collect all those beers from you and others (<!profile=Steve_in_Kent>Steve_in_Kent<!/profile>, for example), I am going to be seriously drunk! Does the offer include a stay in a detox clinic?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •