 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2005Mailmerge from VB to WORD 2002 with Access
I have an application that uses Mailmerge into Word 2002 from an Access database. At this point I'm extremely frustrated as this is a late delivery on a commercial application. The problem is that it runs on two machines that I have that have Word 2002, but refuses to behave on the client machine. The behavior on my machine is that the template document opens and then is replaced with the filled document. On the client machine the template document opens, but then an empty Word dialog (no document) pops up. It seems that the replacement starts to activate, and then fails for no apparent reason. Any comments would be extremely helpful. ADDENDUM There is no blank WORD dialog. The template document opens and the fill activity fails to take place. I did a test using msg to check the variables and there was no change between my machine and the client. > I have an application that uses Mailmerge into Word 2002 from an Access > database. At this point I'm extremely frustrated as this is a late [quoted text clipped - 10 lines] > > Any comments would be extremely helpful. That's still nowhere near enough to go on save that if it works on one machine and not another, it must be something peculiar about that machine that is causing the problem.  SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP > ADDENDUM > [quoted text clipped - 19 lines] >> >> Any comments would be extremely helpful. The code that fails is: With oDobj.ActiveWindow.Document .MailMerge.OpenDataSource Name:=stConn, SQLStatement:=strSQL, SubType:=wdMergeSubTypeWord2000 .MailMerge.Execute (etc.) The development machine is running XP pro. The test machine is running Win 2000. The connect := is not used. I tested with and without the connect with no affect on the process. > That's still nowhere near enough to go on save that if it works on one > machine and not another, it must be something peculiar about that machine [quoted text clipped - 30 lines] > >> > >> Any comments would be extremely helpful. While the SubType attribute does appear when entering the .OpenDataSource into the VBE, it is not documented in the Help file so I don't know what it does. I would suggest that you try deleting it. SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP > The code that fails is: > [quoted text clipped - 51 lines] >> >> >> >> Any comments would be extremely helpful. The SubType is a new 'feature' provided by MS because of changes made to MS Word that allows for 'backward' compatibility with earlier versions of Word. It is, indeed, undocumented, which is also mentioned in the MSDN postings. Without SubType, the application won't run on my machine. MS says this should allow the expected process to occur on any machine with Word 2002, which is where I have a problem, as this is apparently not the case.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.