MailMerge problem in XP

C

Chris Kennedy

I have a VBA procedure in Access which opens up Word and creates a
mail merge based on a dynamicly created SQL statement. It works in
Word 2000 but not in XP. In XP I get a 'data source could not be
opened' error. It connects via OLEDB. I am also sure it is not a
network security issue as the two machines access the same network
share but using XP and 2000 respectively. Unfortunately I don't have
the code at hand. I was just wondering if there was something obvious.
 
H

Harold Kless

Hi Chris,
You might want to try using the Subtype property in the Connection string.
SubType:=8 'wdMergeSubTypeWord2000

If you're using the code for both Word 2000 and 2002, you will need to test
the version and not use Subtype if the Word version is not Word 2002.

This article discusses subtype
324378 WD2002: Undocumented OpenDataSource Method Expression [SubType]
http://support.microsoft.com/?id=324378


--
Harold Kless, MCSD
Support Professional
Microsoft Technical Support for Business Applications
(e-mail address removed)

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top