Word MailMerge & Excel

  mmmmmm 11:37 16 Mar 03
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 03

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

  brambles 20:13 16 Mar 03

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 03

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

  AndyJ 21:37 16 Mar 03

Oops, sorry....mucked the link up

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

  AndyJ 21:38 16 Mar 03

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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…