Hi Chris,
Windows XP doesn't come with VFP ODBC driver installed. You can download it from
http://msdn.microsoft.com/vfoxpro/downloads/addons/odbc.asp. Take also look at
Word Merge Feature doesn't Work in Windows XP or After Windows XP Upgrade at
http://www.visualpractice.com/xp_merge.shtml>Hi everyone - I am having a bit of trouble getting a mail merge to work with Office XP SP1 (Word 2002). I am using Visual Foxpro 6 SP5 on Windows XP SP1. I have also downloaded and installed the Visual Foxpro driver.
>
>The code was originally written (with help from UT members) for use with Office 2000 and worked OK. It allowed the user to create a mail merge template in Word connecting to the data source using MSQuery to join two tables via the ODBC driver - with our program the user could then pick up the created template and store it so that successive merges could be performed. It was particularly slick or pretty but it gave the users the flexibility they wanted.
>
>I have two problems with this procedure and office XP...
>
>1. I cannot see how to connect two tables and produce a mail merge in office XP (sorry as this is an office question really!)
>2. I need some help/ideas with the code to get it working with both Office 2000 and XP.
>
>Here's what we used with Office 2000...
>
< snip >
--sb--