Group:  Microsoft Word ยป microsoft.public.word.mailmerge.fields
Thread: Merge selected records

Geek News

Merge selected records
Judy Southwell 6/21/2007 6:36:01 PM
I have one Word database and one main document. I want to merge three
different types of letters using the same database. The fiield names that
identify the type of letter are: 'letter_a' 'letter_b' and 'letter_c'. Any
suggestions on the preferred field code I should use and the information I
should include for the parameters?

Appreciate your help,
Judy
Re: Merge selected records
"Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/21/2007 7:32:47 PM
Do you mean
a. "What should I store in the field?" or
b. "How should I set up my Mail Merge Main Document to do the merge? or
perhaps
c. both?

If it's (a), I would put a 1 in the field if I wanted to print the letter
and either nothing or 0 if I didn't want to print the letter.

If it's (b), although it's possible to do something like

{ IF "{ MERGEFIELD letter_a }" = "1" "all the text and fields you want for
letter A"
}{ IF "{ MERGEFIELD letter_b }" = "1" "all the text and fields you want for
letter B"
}{ IF "{ MERGEFIELD letter_c }" = "1" "all the text and fields you want for
letter C"
}

and variations on that theme, I think it's generally better to do one merge
for each letter type and use the Mail Merge Selection options to select
letter_a Equals 1 for the first letter etc.

But I would experiment anyway, particularly with the selection stuff, as
WOrd has become more inclined to get that wrong in recent years.

Peter Jamieson

"Judy Southwell" <JudySouthwell[ at ]discussions.microsoft.com> wrote in message
news:863F31E7-FD9E-4F7C-B57A-4869F5738050[ at ]microsoft.com...
[Quoted Text]
>I have one Word database and one main document. I want to merge three
> different types of letters using the same database. The fiield names that
> identify the type of letter are: 'letter_a' 'letter_b' and 'letter_c'.
> Any
> suggestions on the preferred field code I should use and the information I
> should include for the parameters?
>
> Appreciate your help,
> Judy

Re: Merge selected records
Judy Southwell 6/21/2007 8:00:01 PM
Thanks for getting back to me, Peter. I meant:
a. What should be included in the string, e.g. IF {MERGEFIELD, etc.)
b. Basically the same as the above.

I'll try what you suggested, but in the meanwhile I had success with:
{SKIPIF {MERGEFIELD Letter_Type} <> "A"} for those records with a
corresponding A in the Letter_Type field. Then, I changed the A to a B in
the SKIPIF string for the 'B' letters and the same for the 'C' letters.

Judy


"Peter Jamieson" wrote:

[Quoted Text]
> Do you mean
> a. "What should I store in the field?" or
> b. "How should I set up my Mail Merge Main Document to do the merge? or
> perhaps
> c. both?
>
> If it's (a), I would put a 1 in the field if I wanted to print the letter
> and either nothing or 0 if I didn't want to print the letter.
>
> If it's (b), although it's possible to do something like
>
> { IF "{ MERGEFIELD letter_a }" = "1" "all the text and fields you want for
> letter A"
> }{ IF "{ MERGEFIELD letter_b }" = "1" "all the text and fields you want for
> letter B"
> }{ IF "{ MERGEFIELD letter_c }" = "1" "all the text and fields you want for
> letter C"
> }
>
> and variations on that theme, I think it's generally better to do one merge
> for each letter type and use the Mail Merge Selection options to select
> letter_a Equals 1 for the first letter etc.
>
> But I would experiment anyway, particularly with the selection stuff, as
> WOrd has become more inclined to get that wrong in recent years.
>
> Peter Jamieson
>
> "Judy Southwell" <JudySouthwell[ at ]discussions.microsoft.com> wrote in message
> news:863F31E7-FD9E-4F7C-B57A-4869F5738050[ at ]microsoft.com...
> >I have one Word database and one main document. I want to merge three
> > different types of letters using the same database. The fiield names that
> > identify the type of letter are: 'letter_a' 'letter_b' and 'letter_c'.
> > Any
> > suggestions on the preferred field code I should use and the information I
> > should include for the parameters?
> >
> > Appreciate your help,
> > Judy
>
>
Re: Merge selected records
"Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/21/2007 9:04:29 PM
If SKIPIF works OK for you, I'd stick with it. I tend to avoid it simply
because Microsoft recommends that we use the selection criteria instead!

Peter Jamieson

"Judy Southwell" <JudySouthwell[ at ]discussions.microsoft.com> wrote in message
news:1E7B450D-BD95-495F-8EBC-CDA7E72F5EBA[ at ]microsoft.com...
[Quoted Text]
> Thanks for getting back to me, Peter. I meant:
> a. What should be included in the string, e.g. IF {MERGEFIELD, etc.)
> b. Basically the same as the above.
>
> I'll try what you suggested, but in the meanwhile I had success with:
> {SKIPIF {MERGEFIELD Letter_Type} <> "A"} for those records with a
> corresponding A in the Letter_Type field. Then, I changed the A to a B in
> the SKIPIF string for the 'B' letters and the same for the 'C' letters.
>
> Judy
>
>
> "Peter Jamieson" wrote:
>
>> Do you mean
>> a. "What should I store in the field?" or
>> b. "How should I set up my Mail Merge Main Document to do the merge? or
>> perhaps
>> c. both?
>>
>> If it's (a), I would put a 1 in the field if I wanted to print the letter
>> and either nothing or 0 if I didn't want to print the letter.
>>
>> If it's (b), although it's possible to do something like
>>
>> { IF "{ MERGEFIELD letter_a }" = "1" "all the text and fields you want
>> for
>> letter A"
>> }{ IF "{ MERGEFIELD letter_b }" = "1" "all the text and fields you want
>> for
>> letter B"
>> }{ IF "{ MERGEFIELD letter_c }" = "1" "all the text and fields you want
>> for
>> letter C"
>> }
>>
>> and variations on that theme, I think it's generally better to do one
>> merge
>> for each letter type and use the Mail Merge Selection options to select
>> letter_a Equals 1 for the first letter etc.
>>
>> But I would experiment anyway, particularly with the selection stuff, as
>> WOrd has become more inclined to get that wrong in recent years.
>>
>> Peter Jamieson
>>
>> "Judy Southwell" <JudySouthwell[ at ]discussions.microsoft.com> wrote in
>> message
>> news:863F31E7-FD9E-4F7C-B57A-4869F5738050[ at ]microsoft.com...
>> >I have one Word database and one main document. I want to merge three
>> > different types of letters using the same database. The fiield names
>> > that
>> > identify the type of letter are: 'letter_a' 'letter_b' and 'letter_c'.
>> > Any
>> > suggestions on the preferred field code I should use and the
>> > information I
>> > should include for the parameters?
>> >
>> > Appreciate your help,
>> > Judy
>>
>>

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net