OK this should be relatively easy but I think my brain has finally melted!
I'm putting together a quick and nasty mailmerge button in my .adp to launch mailmerge in ms word.
This code works fine:
DoCmd.SelectObject acServerView, "vwSubscriptionContacts", True
DoCmd.RunCommand acCmdWordMailMerge
However I can't remember how I'd apply a WHERE condition to it to refine the data eg "WHERE iwfSubsription = 3".
Any help gratly apriciated
I'm putting together a quick and nasty mailmerge button in my .adp to launch mailmerge in ms word.
This code works fine:
DoCmd.SelectObject acServerView, "vwSubscriptionContacts", True
DoCmd.RunCommand acCmdWordMailMerge
However I can't remember how I'd apply a WHERE condition to it to refine the data eg "WHERE iwfSubsription = 3".
Any help gratly apriciated