>Hi Sean,
>
>I have been busy with this problem since last, and think I have found some answers, but not all.
>
>First, I am using the macro facilitiy in Word97. The SQLSelect statement doesn't seem to accept any parameters. But, I have found the following in the help file:
>
>Set myMMData = ActiveDocument.MailMerge.DataSource
>If myMMData.FindRecord(Find Text:="Peter",Field:="Name") = True Then
> numRecord = myMMData.ActiveRecord
>End If
>
>By inserting this code after the SQL, I get the record that I want. That I get the record also when I replace the "True" keyword with "False", except that the numRecord of course will not be set. But, since I don't know what to do with the record number anyway, that is'nt imporant. I have however another wuestion now: When I have found the record that I want, and it has been inserted into a Word document, I also want to check the contents of another field in the record, to decide further action to take. How do I do that?
>
>Rolf
Rolf,
You should be able to test any additional fields in the current record by -- myMMData.Fields("name of field here") -- of course you can only do this following your previous code above.
sc
Sean Campbell
www.upstagesoftware.comsc@upstagesoftware.com**********************************************************
Eddie, I wouldn't be anymore surprised, if tomorrow I woke up with my face stapled to the living room carpet.
Clark W. Griswold
**********************************************************