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

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Access/Word Mail Merge 2003

Reply to Message Icon

Name: Datatonic
Date: February 28, 2005 at 06:13:29 Pacific
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



Sponsored Link
Ads by Google

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

Fixed it myself

This knowledge base fix does the job.

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


0
Reply to Message Icon

Related Posts

See More







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


Sponsored links

Ads by Google


Results for: Access/Word Mail Merge 2003

MS Word Mail Merge Crash www.computing.net/answers/office/ms-word-mail-merge-crash/5878.html

Word mail merge problem www.computing.net/answers/office/word-mail-merge-problem/3758.html

Microsoft Access 2002 mail merging www.computing.net/answers/office/microsoft-access-2002-mail-merging-/4965.html