Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2011, 02:21 AM
macropod's Avatar
macropod macropod is online now Simplified Mail Merge From a Query Windows 7 32bit Simplified Mail Merge From a Query Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,363
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simplified Mail Merge From a Query Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
Word (Mail Merge) Refreshes Query Too Often! amarsha4 Mail Merge 1 11-10-2010 09:12 AM
mail merge from access query or two tables peter Mail Merge 0 08-24-2010 05:32 PM
Mail Merge Query kangabanga Mail Merge 0 09-25-2008 04:07 AM
Simplified Mail Merge From a Query Access 2003 query with wildcards into Word 2003 mail merge Poingdexter Office 1 10-30-2005 06:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft