Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2001
    Location
    Astcote, Northamptonshire, England
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts

    DDE link for Excel mail merge (W95 Office2000 9.0.2720)

    Message appears advising that there is a missing DDE link when I try to merge Excel data with a Word document. I have set up a pretty simple mail merge which takes entries in an Excel database and pops them into various places on a form in Word. The process works fine on my own PC but here at college it doesn't. I'm confident that I've set up the documents correctly but our internal technicians have been unable to help. I feel that it's something I should be able to resolve myself if someone could point me in the right direction. Any suggestions welcome.

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

    Re: DDE link for Excel mail merge (W95 Office2000 9.0.2720)

    Does <!post=this post,128577>this post<!/post> help?

  3. #3
    New Lounger
    Join Date
    Jul 2001
    Location
    Astcote, Northamptonshire, England
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: DDE link for Excel mail merge (W95 Office2000 9.0.2720)

    Thanks for the reply, Phil. It's now Saturday this side of the pond so I'm not at the PC with the software that is causing all the trouble. I suspect that on Monday IT Services will have taken the box away and simply reformat and hope it all works fine when reinstalled! It may be that that is the sensible solution but I would really like to know how to revive a DDE link and to understand why it ceased to function. I teach this stuff (OK at a pretty modest level) and like to be able to answer others' queries. I have learned something new from you for which I am grateful. I'd looked at this before posting but hadn't read all the way through! Another solution thathad come to mind was to transfer the Excel data into word as a table and use Word's own 'mail'merge feature. It occurs to me that this cannot surely be a Method3!! I guess it's a variation of one of your two. Interested to know what you think and any further thoughts on DDE welcome. Cheers. Incidentally, I'm not a New Lounger - I've even replied to a few but must have got lost. It was a while ago.
    Andrew

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

    Re: DDE link for Excel mail merge (W95 Office2000 9.0.2720)

    Hi Andrew:
    You certainly could paste the Excel data into Word & use a Word table. I'm not really sure why you got the message & whether anything was corrupt. If they've taken away your machine, you may never know. <img src=/S/smile.gif border=0 alt=smile width=15 height=15> And welcome back to the Lounge.

Posting Permissions

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