Re: Filtering mail merge records....

From: Charles Kenyon (msnewsgroup_at_remove.no.spam.addbalance.com)
Date: 03/19/04

• Next message: Becky: "Field Calculation Error"
• Previous message: Graham Mayor: "Re: Switches for formatting a merge field"
• In reply to: Barry: "Re: Filtering mail merge records...."
• Messages sorted by: [ date ] [ thread ]

Date: Fri, 19 Mar 2004 12:28:24 -0600

{ IF "{ Mergefield "First2"}" <> "" "{ Mergefield "First1" } and
{ Mergefield "First2" }" "{ Mergefield "First1" }" \* Charformat }

-- 
Charles Kenyon
See the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
 --------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
"Barry" <anonymous@discussions.microsoft.com> wrote in message
news:1040101c40dda$072bf750$a301280a@phx.gbl...
> Hi Charles!
> Thank you again!  I really appreciate your time and
> insight.
> Actually, doing a single mail merge would better suit my
> purposes.  If nothing else using the two queries as data
> sources changes the sort order I need to do the mailing.
> I have read, re-read, and read again, but I think I am
> missing something.
> In your original reply you stated "If there isn't a
> checkbox field but simply you use First2 when it is a
> couple and don't for a single person, you could test for {
> IF "{ Mergefield
> "First2"}" <> "" ..."  What goes after the ellipsss???
> Thanks!
> Barry
>
> >-----Original Message-----
> >Go back and re-read my previous post. In your situation
> you can do it with a
> >single merge. You test for a blank SpouseName field. In
> my post I used
> >First2 as the field you apparently have for SpouseName.
> >
> >One (non-Word) problem you may have is that not all
> spouses share surnames.
> >(And not all people residing in the same household with
> the same surname are
> >spouses; I resided with my sister for a few months a
> while back.) The
> >purpose of doing such a customized merge is to
> personalize letters.
> >Personalization that shows you don't know the people can
> have the opposite
> >effect.
> >-- 
> >
> >Charles Kenyon
> >
> >See the MVP FAQ: <URL: http://www.mvps.org/word/> which
> is awesome!
> > --------- --------- --------- --------- --------- -------
> --
> >This message is posted to a newsgroup. Please post replies
> >and questions to the newsgroup so that others can learn
> >from my ignorance and your wisdom.
> >
> >"Barry" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:9DFCEE32-6652-41EA-9264-8573E53D03C2@microsoft.com...
> >> Hi Charles!
> >> Thank you for your reply, I sincerely appreciate it.
> >> I will make a note of your solution and perhaps give it
> a try in the
> >future.  In my database I do not have a field that
> distinguishes an
> >individual from a married couple.  As a workaround I
> created two queries in
> >my database:  one returns all the records where the
> field "SpouseName" is
> >null or empty which I will use as the data source with
> which to print the
> >letters and labels to individuals.  The other query
> returns records where
> >the field "SpouseName" is not null which I will use as
> the data source for
> >my mail merge to couples.
> >>
> >> Thanks!!!
> >> Barry
> >
> >
> >.
> >

• Next message: Becky: "Field Calculation Error"
• Previous message: Graham Mayor: "Re: Switches for formatting a merge field"
• In reply to: Barry: "Re: Filtering mail merge records...."
• Messages sorted by: [ date ] [ thread ]

• Windows
• Science
• Usenet

• Archive
• About
• Privacy
• Search
• Imprint