[mso] Making the computer think before a Word Mail merge
- From: "Kathie Felts" <subscriptions@xxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Tue, 16 Nov 2004 12:49:46 -0600
Don't mean to insult the computer, I'm just wondering if Access or Excel
is the best source of info if, when I merge my mailing I want to have a
merge field that is "last gift +50% rounded to the nearest $5 increment"
and a few others that do math based on previous giving. I've stepped away
from my access programming (god I was dumb to start!) but I'm moderately
happy with what I have, and don't have the time to program this into the
database even if I wanted to.
So, do I merge from Access and find a way to do math in the merge, or, do
I export to Excel and find a way to do the math in the merge, or do I
export to Excel, and program columns to do the math, then merge.
AND, if I do the math in Excel and then merge, maybe I want to program the
columns to say "if the last gift is between X Y, then the three suggested
gifts should be ABC" and "if the last gift is more than Y, the suggested
gifts should be CDE, and if less than X, then it should be something less
than ABC"
What do you think, oh wise ones?
I'm on a pc with XP, presumably Office XP, 90% sure.
Kathie
--
Kathie Felts
Executive Director
Blooming Prairie Center
Deep Roots, Bright Futures, Unlimited Horizons
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
