Mail merge data source can't be saved word 2003

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: richie (mailtrax2004_at_yahoo.com)
Date: 04/27/04


Date: 27 Apr 2004 08:34:37 -0700

I have an access dbase access 2000 format that has been working fine
with a mail merge with MS word 97, 2000, & Xp, however with Word 2003
Excel doesn't
open and the data source cannot be saved in Word i.e. ( it loses its
connection each time). I've included the code but I have a feeling it
is
more of a Word 2003 issue.
 
Any ideas would be greatly appreciated.
 
 
Case "First Box Renewal Notice"
Dim wd As Word.Application
 DoCmd.OutputTo acQuery, "Mail merge first notice",
"MicrosoftExcel(*.xls)", "c:\mail trax\Mail merge first notice.xls",
False, ""

Set wd = CreateObject("word.application")
wd.Visible = True
wd.Activate
wd.Documents.Open "C:\Mail trax\box renewal notice.doc"