The advice below is a pretty good technical answer to the question. Beyond
that, however, is the more annoying human question of how to make sure
those queries are run the same way every time. There are basically two
approaches, which may be used separately or in combination: The simple way
is to *type up* a detailed step by step procedure for each database run you
make, put these all in a book, and make sure that everyone who might
conceivably touch the computer is trained to do everything by the book.
The second approach, a more classical data processing procedure, is to
create a canned query for each job, and run these queries by name. It can
be helpful if the canned queries are also documented in a book.
Barry
At 01:54 PM 04/20/2001, you wrote:
>Cathy,
>
>In answer to #2, all you need to do to "flag" this member is to use the
>Contact Flag check boxes on the Data Entry screen (at least that's what I
>do). Put a "N" for no in the "solicit", "calls", and "renewal" boxes and
>put a "Y" in your newsletter, alerts or other boxes to indicate the
>information you want to send to this person.
>
>When you do your search for renewal letters, solicitations, etc, just make
>sure you add another find to your search/query and click the Omit button
>for the find and enter "N" in the solicitation, calls, or renewals box
>(which ever is appropriate for the particular search). This will remove
>this individual from your found set (make sure to do the omit as your last
>find)
>
>When you run your search for who you are sending newsletters to, add
>another find for "Y" in the newsletter box, etc. and you can make sure this
>person is getting the newsletter, etc.
>
>Others may have some better suggestions, but this should work for what you
>are trying to do. Hope this helps.
>
>Glenn Marangelo
>
>
>Wilderness Watch
>P.O. Box 9175
>Missoula, MT 59807
>406-542-2048
>fax: 406-542-7714
>[EMAIL PROTECTED]
>www.wildernesswatch.org
>
>------------------
>Reminder to each recipient: To change your list account preferences, go to
>http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the
>email address you used to subscribe to the ebase support list::
>[EMAIL PROTECTED]
>
>To unsubscribe send a blank email to [EMAIL PROTECTED]
>---------------------------------------------------------------------
> ebase - Relationship Management for Nonprofits, http://www.ebase.org
>---------------------------------------------------------------------
Barry L. Newton, Ashton Computing & Management Services
[EMAIL PROTECTED]
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
