How to do mail merge after applying filter

[naxi]

Hi

After I make filter and apply it on a ResultForm (which represent query ) I can see results like this:

DoCmd.OpenForm "ResultForm", , , strFilter, acFormReadOnly

or I can print report like this:

DoCmd.OpenReport "MainReportForSearch", acViewPreview, , strFilter


My problem is how can I use filtered data for mail merge?
I need a query which as a data source.

How can I make a query from filtered data?

Thanks

 

[neileg]

Ditch your filter and use a query instead. Then you can use the query for the form and the mailemerge.