more than one name (maybe) in greeting line.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

theoldmole@gmail.com - 15 Aug 2006 02:22 GMT

I want my greeting line to say:

Dear Mr. Smith and Ms. Jones,

if there is a Ms. Jones (title2 and lastname2)

Dear Mr. Smith,

if there's no Ms. Jones,

Dear Friends,

if there's no Mr. Smith or Mr. Jones.

Here's how I've set it up. I don't know if this will show up if I print
it exactly as I see it on the page, so I'll substitute < for {

Dear < IF <MERGEFIELD Title > = "" "Friends" "" ><MERGEFIELD "Title" >
<MERGEFIELD "Last_Name" >< IF <MERGEFIELD Title > = "M**" "and" ""

><MERGEFIELD "Title2" > <MERGEFIELD "Last_Name2" >,

When this merges, I get

Dear Mr. SmithandMs. Jones,

When there's no Ms. Jones, I get

Dear Mr. Smith , (space before comma)

When it's "friends," I get

Dear friends ,

How do I fix this?

Reply to this Message

Graham Mayor - 15 Aug 2006 07:57 GMT

It would be better if you copied the fields exactly to reveal the extra
space (you could use the macro at http://www.gmayor.com/export_field.htm to
aid that) which should probably give you something like:

Dear { IF{ Mergefield Title } = "" "Friends" "{ Mergefield Title } {
Mergefield Last_Name }"}{ IF{ Mergefield Title} = "M??" " and { Mergefield
Title2 } { Mergefield Last_Name2 }" },

or

Dear { IF{ Mergefield Title } = "" "Friends" "{ Mergefield Title } {
Mergefield Last_Name }"}{ IF{ Mergefield Title2} <> "" " and { Mergefield
Title2 } { Mergefield Last_Name2 }" },

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I want my greeting line to say:
>
[quoted text clipped - 30 lines]
>
> How do I fix this?

Reply to this Message