Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-02-2011, 05:40 PM
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,521
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,



In Word, you can use SKIPIF fields to specify that records should be omitted when one or more fields meet/don't meet certain criteria. If you want, you can combine these with FILLIN and/or ASK fields to prompt the user for a given criterion's value.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 05-03-2011, 01:45 AM
Evis Evis is offline Simplified Mail Merge From a Query Windows 7 64bit Simplified Mail Merge From a Query Office 2007
Novice
Simplified Mail Merge From a Query
 
Join Date: May 2011
Posts: 3
Evis is on a distinguished road
Default

Thanks for the reply macropod, I'm not sure how I'm supposed to use those commands to bypass the problem though? It seems to be the case that Word simply can't use a query without parameters that were already set in Access. It consistently fails to make the 'initial link' between the query and the document, regardless of how I begin the merge. Unless I set definate paramters in the Access query.

Just to offer a little more information, the query is a simple one: Each person on the database is assigned a contact group. The Query has one parameter, the contact group, and so the mail merge is sent to everyone in the selected group. What I would like is a way for the user to set the contact group the query is using without the need to teach her to use the query design. The normal methods of doing this though [such as user defined criteria] , seem to make the query incompatible with a mail merge.
Reply With Quote
Reply



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 01:03 PM.


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