[mso] Re: Making the computer think before a Word Mail merge
- From: "Green" <1z@xxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 16 Nov 2004 21:43:11 +0100
Kathie,
> I'm moderately
> happy with what I have
What's that?
If it's access... what *exactly* do you need?
What are "a few others"?
If you outline the problem in enough detail then the solution may
present itself... with no programming :-)
IMHO Assuming you are doing your merge to word... I would personally
say don't make life any more complex for yourself.
If you have to do the art=ithmetic in Excel then you may as well do it
it access and save the export step and keep one set of data around.
FWIW .. and again assuming your data is in access... I'd go with
queries.
HTH
Lisa
> 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
*************************************************************
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:
