By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,446 Members | 3,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,446 IT Pros & Developers. It's quick & easy.

Access 2003 to Word 2003 Mail Merge

P: 3
Help!!!

What am I doing wrong? I am working with Office 2003 and am trying to create a command button on an Access form that will create a mail merge in Word from an Access table.

I want to make the mail merge seamless to the user so all they have to do is click on the command button and the letters are generated.

For the button I created an event procedure with the following code:

Private Sub RunLetters_Click()

Dim objWord As Word.Document
Set objWord = GetObject("C:\Temp\Download\Access to Word\MERGE LETTER.doc", "Word.Document")

'Make Word visible.
objWord.Application.Visible = True

'Set Mail Merge Data Source
objWord.MailMerge.OpenDataSource NAME:="C:\Access2003\RonWorkingOn\Copy of NewVersion.mdb", _
LinkToSource:=True, _
Connection:="TABLE LETTER SENT PULL TABLE", _
SQLStatement:="SELECT * FROM LETTER SENT PULL TABLE"

'Execute the mail merge.
objWord.MailMerg.Execute

End Sub

When I click on the button I always get a Microsoft Office Word message box that says:
Opening this document will run the following SQL command:
SELECT * FROM [LENDER SENT PULL TABLE]
Data from your database will be place in the document. Do you want to continue?

I click on Yes then after a short wait Word opens and the master merge letter opens and I get another message box that says:
Confirm Data Source
OLE DB Database Files
MSAccess database via DDE(*mdb.*mde)
MSAccess database via ODB(*.mdb)

When I pick the 1st choice - nothing happens and I close Word and am back in Access and have a Microsoft Visual Basic message box that says:
Run-time error 4198
Command failed

When I pick the 2nd choice - again nothing happens and I close Word and am back in Access and have another Microsoft Visual Basic message box that says:
Run-time error 5922
Word was unable to open the data source

When I pick the 3rd choice - a message box comes up asking me to pick the Table and I click on the desired table.

Again the same thing happens as when I pick the 2nd choice.

Can anyone please help me? I have tried everything I could find and nothing is working.

Thanks,

Ron
Nov 3 '06 #1
Share this Question
Share on Google+
8 Replies


southoz
P: 24
check your PM's for an answer


southoz
Nov 4 '06 #2

PEB
Expert 100+
P: 1,418
PEB
It's interesting to have the answer also in the forum :)
check your PM's for an answer


southoz
Nov 4 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Try changing this line to:

SQLStatement:="SELECT * FROM [LETTER SENT PULL TABLE];"
Nov 7 '06 #4

P: 3
To southoz,

Thanks for your reply. Unfortunately when I try to go to members.dodo.com/au/gjevers/gregw.zip I get Page does not exist.

Have I got the url wrong?

Ron
Nov 10 '06 #5

P: 3
To mmccarthy,

Thanks for your recommendation. I tried it and it did not work either.

I am desperate for any ideas so if you have any more please send them.

Thank again,

Ron
Nov 10 '06 #6

MitchR
P: 63
Does Word 2003 have to house the form letter .... i have script that will generate a text email and send with you respective data from the form ....
Nov 10 '06 #7

southoz
P: 24
Good ay Ron B

I have posted the code to this forum follow this link http://www.thescripts.com/forum/thread559954.html

I also have the fall demo database on my site http://members.dodo.com.au/gjevers/gregw.zip

hope this helps
southoz
Nov 10 '06 #8

NeoPa
Expert Mod 15k+
P: 31,494
Good 'ay SouthOz.

That's a good way to provide the answer - a reusable thread - I like it.
Nov 11 '06 #9

Post your reply

Sign in to post your reply or Sign up for a free account.