Hi Peter,
No dialogue box opens behind the window - as soon as I hit "Get Data"
WinWord freezes "not responding".
I've read pages of posts on the internet, lots of people get this message,
but I haven't yet seen a solution to it. Some people have got it with an
already existing merge document - for some reason the merge process fails
and they have been advised to rename the Data file - then when Word tries to
merge, it seeks the Data file, can't find it, asks for the name and location
and then the new data file is selected and the merge then goes ahead.
Unfortunately I can't even get that far.
I did wonder - When I restored my computer in early Jan, my HP Recovery
disks installed a different version of Word - I'm not even sure which
exactly, but I uninstalled it as I wanted Office Professional - could I have
inadvertently deleted some files? I can't remember if I uninstalled before
or after I installed Office Professional.
Thanks for your help.
Laura
"Peter Jamieson" wrote in message
...
If any dialog box would open when you open access or your database, it
will open when Word starts Access via DDE. Sometimes (often) that dialog
box is displayed behind Word so you cannot see it. Nothing appears to be
happening.
Alt-tab to see if there is such a dialog box.
Peter Jamieson
http://tips.pjmsn.me.uk
Laura wrote:
Hi Doug,
Boy do I need you right now.. I don't know what else to do. I have a
laptop next to me with a similar configuration and it works, but not on
my PC. i.e., same operating system and same version of Office.
The Option "Ignore DDE requests" is and was unchecked on both machines.
The Option "Enable DDE refresh" IS checked.
What else can it be? I need to do this mailmerge on the PC, if possible.
Could it be an XP issue?
Laura
"Doug Robbins - Word MVP on news.microsoft.com"
wrote in message ...
From the Tools menu in Access, select Options and then go to the
advanced tab and make sure that the Ignore DDE requests box is
unchecked.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Laura" wrote in message
...
I hope someone can help me soon as I'm very frustrated. I have Office
2000 Professional and Windows XP SP3. I recently reinstalled everything
on my computer after doing a system restore and for some reason which I
cannot work out, I cannot do a Mail Merge using a Table in Access (or
even a Spreadsheet in Excel) with Word.
I have my Word document open and I click on Tools, Mail Merge, Active
Window. When I click on Get Data and locate my Access table it opens
the Access table and then it hangs and eventually I have to quit Word
all together. I see this message on the status bar of Word -
waiting for microsoft access to accept dde commands
But nothing happens. I'm at my wits end. I have uninstalled Office and
re-installed it.. still nothing. What is the problem? Hope someone can
help soon - I have a huge mailmerge to do tomorrow.
Thanks
Laura