Word MailMerge & Excel

  mmmmmm 11:37 16 Mar 2003
Locked

I am having problems with linking any Word MailMege document to Excel. I am using Office 2000 with Windows 2000 Professional and have had no problem with this until recently.

The message "Waiting for Microsoft Excel to accept DDE commands" shows in the status bar and it goes no further. I then have to go to task manager and stop the "not responding" Word program.

I have got a workaround from the Microsoft website by selecting the method of using the data source of "Microsoft Excel Worksheet via converter" which is fine for new documents, but any existing MailMerge file just hangs...

Would be grateful for any advice!

Phil Birch

  recap 15:48 16 Mar 2003

In Excel: Tools, Options, General tab, uncheck "Ignore Other Applications" may work.

  brambles 20:13 16 Mar 2003

I would recommend that you open Excel/Select all & copy.

Open Word & paste into a new file - name it whatever - it will be in table form & providing you have copied the headers as well then the whole mail merge can be in Word.

Please try it I do this regularly for various reasons.

Brambles

  AndyJ 21:35 16 Mar 2003

Don't know if this will help
http:// support.microsoft. com/support/kb/articles/q212/3/14.asp

  AndyJ 21:37 16 Mar 2003

Oops, sorry....mucked the link up

click here. com/support/kb/articles/q212/3/14.asp

  AndyJ 21:38 16 Mar 2003

Don't believe it....did it again...it's been a bad day !!! Try again

click here

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?