If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Word 2007 Mail Merge fail
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 |
#2
|
|||
|
|||
Word 2007 Mail Merge fail
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 petz wrote: 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 |
#3
|
|||
|
|||
Word 2007 Mail Merge fail
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'. -- Cheers macropod [Microsoft MVP - Word] "petz" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|