Word 2007 Mail Merge fail

[petz]

I support a system that has several functions that open Word and merge data
from this system into Word templates using VB 6.5. These functions have
performed without major issues with previous versions of Word, but we’ve run
into some problems with Word 2007 that we can’t seem to get around.

When Outlook (2007) is open, the macro loops trying to open the templates
until our system throws an error. The macro appears to be running into
something in Outlook that wants to run it, but can’t. When Outlook is not
open the macro runs fine. The only way we can get this function to run with
Outlook open, is by opening an instance of Word.

In addition, when the templates do open, side and bottom scroll bar and
mousing functions don’t work. The only way to move around in the document is
by using the arrow keys. This trait is picked up by Word documents open at
that time.

We also get the "Save As" dialog instead of the "Do you want to save..."
pop. This can recur numerous times but there's no consistent result. It may
pop 7 or 8 times, or not at all.

Some responses out here shrug it off as a fault with our system and not
Office 2007. If it's worked with all previous versions of Word and the
associated operating systems, and it fails with Vista/Office 2007, that tells
me there's something with the OS or Word that we should be able to work with
to make our macro run. We can make changes to the macro if needed but we need
to have an idea what to look at.

Is anyone else having any or all of these problems with Word 2007??

Thanks all

 

[Peter Jamieson]

Just a guess - one possibility is that because Outlook 2007 uses a
version of Word as its editor, you might be running into problems to do
with "which instance of Word are you actually automating" - e.g. if your
VB software expected to connect to an existing Word instance if one
existed, or create one if it did not, you may now find that it is not
doing quite the same thing.

Actually I don't find that entirely convincing but it's the first thing
I'd check here, just to be sure.

Peter Jamieson

http://tips.pjmsn.me.uk

 

[macropod]

Hi petz,

Check that the file paths you're working with are correct. For example, in previous versions of Windows, user files were typically
under 'My Documents', but user files under Vista are typically under 'Documents'.