merging with query in access 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jbc - 09 Feb 2007 15:42 GMT

Hi,

I would like to automate merging between word and access 2003. I had code
that worked in 2000, but now I'm getting error messages.

Thanks.

jbc

Reply to this Message

jbc - 09 Feb 2007 17:24 GMT

I also want to note that the code should open access if necessary and run the
merge.

thanks.

> Hi,
>
[quoted text clipped - 4 lines]
>
> jbc

Reply to this Message

Doug Robbins - Word MVP - 09 Feb 2007 19:07 GMT

It might help if you posted the code that you were using and indicated what
line of code was highlighted when the error occurs.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I also want to note that the code should open access if necessary and run
>the
[quoted text clipped - 11 lines]
>>
>> jbc

Reply to this Message

jbc - 09 Feb 2007 19:37 GMT

Doug,

This is the code I'm using. I recorded it in Word. I'm getting a dialog
box that asks me to confirm data source. When I choose MS Access Databases
with DDE it works.

ActiveDocument.MailMerge.OpenDataSource Name:= _
"C:\Documents and Settings\jbc\My Documents\Member\Membership.mdb" _
, ConfirmConversions:=True, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=wdOpenFormatAuto, Connection:= _
"QUERY qryRenewalForm1", SQLStatement:= _
"SELECT * FROM [qryRenewalForm1]", SQLStatement1:="", _
SubType:=wdMergeSubTypeOther

With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.Execute
End With

Thanks.

jbc

> It might help if you posted the code that you were using and indicated what
> line of code was highlighted when the error occurs.
[quoted text clipped - 14 lines]
> >>
> >> jbc

Reply to this Message