lil help with SELECT statement

[CandyBoy]

Here is the code I am using for a mail merge but I get an error msg in the last line.
works fine when using a table but not with a query, any suggestions?

objWord.MailMerge.OpenDataSource _
Name:="m:\DecPage.mdb", _
LinkToSource:=True, _
Connection:="QUERY Merge", _
SQLStatement:="SELECT * FROM [Merge]"

 

[CandyBoy]

also if anyone could help with some code that would set the record on the merge to the same one as the one on the form, it would be greatly appreciated.