.ADP Filter View & use as source for Word Merge Wizard

O

ozinm

Hi all.
I'm trying to use the built in mailmerge wizard in a 2003 MS Access Project
(.ADP) to merge filtered data from a view.

This code seems to do partly what I want:
DoCmd.SelectObject acServerView, "vwSubscriptionContacts", True
DoCmd.RunCommand acCmdWordMailMerge

HOWEVER:
how can I filter the vwSubscriptionContacts view (eg "WHERE iwfSubsription =
3").
Do I have to do something else instead?
DOes anyone have any possible solutions?

Thanks in advance for any suggestions/help

All the best.

M.
 
Top