Computing.Net > Forums > Office Software > Access/Word Mail Merge 2003

Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free!

Access/Word Mail Merge 2003

Reply to Message Icon

Original Message
Name: Datatonic
Date: February 28, 2005 at 06:13:29 Pacific
Subject: Access/Word Mail Merge 2003
OS: xp
CPU/Ram: athlon 1gb
Comment:

I have a database that has various mail merge word templates that it uses.

My client has just upgraded from Office XP to Office 2003.

All the mail-merge templates now no longer populate with data.

If you open them in Word they create the link and prompt for the value that should be in the related form and run the query no problem.

When you access them from Access they don't have the data passed to them. No errors come up but they data fails to pass over.

The code I am using is as follows:-

Dim stDocName As String

If (ChildID.Value > 0) Then
stDocName = "QryLetterB"
DoCmd.OpenQuery stDocName, acNormal, acEdit
Set rst = New ADODB.Recordset
rst.ActiveConnection = CurrentProject.Connection
rst.CursorType = adOpenDynamic
rst.LockType = adLockOptimistic
rst.Open "select * from tblChild"
'Open word document
Dim oApp As Object
Set oApp = CreateObject("Word.Application")
oApp.Visible = True
oApp.documents.Add "c:\Database\Templates\Letters\Blank.dot"
DoCmd.Close acForm, "FrmBlank"
DoCmd.Close acQuery, "QryLetterB"
Else
MsgBox "Please select a child"
End If

What has changed in 2003 and how do I go about fixing it?

Thanks


Report Offensive Message For Removal


Response Number 1
Name: Datatonic
Date: March 1, 2005 at 02:11:54 Pacific
Reply: (edit)

Fixed it myself

This knowledge base fix does the job.

http://support.microsoft.com/?kbid=825765


Report Offensive Follow Up For Removal







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home








Do you own an iPhone?

Yes
No, but soon
No


View Results

Poll Finishes In 7 Days.
Discuss in The Lounge
Poll History




Data Recovery Software