Merge with Access 2003

[jbc]

Hi, I have a letter that I need to merge with a query in Access 2003. When
I go to the Open Data Source button and choose my database, I'm not getting a
complete listing of all of my tables and queries to choose from after
selecting the database.

Any ideas what would be causing this?

Thanks.

jbc

 

[Peter Jamieson]

See my recent posts in the conversations titled
"I can't find an Access query which is a Word data source when I tr."
and
"Data Source Lost When Merge From Access to Word"

 

[jbc]

Hi Peter,

I ended up putting it into code:

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

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

Thanks for your help.

jbc