Thread: [Solved] Simplified Mail Merge From a Query
View Single Post
 
Old 05-03-2011, 02:21 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,345
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi evis,

Assuming there's a 'Group' field, it's simply a matter of encoding a SKIPIF field in the mailmerge main document along the lines of:
{SKIPIF{MERGEFIELD Group}<> {FILLIN "Which Group do you want the records for?" \o}}
At the start of the mailmerge, the user will be prompted to input the Group name/ID (whatever it is that identifies Groups). The mailmerge will then only output the records for that Group.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote