[ellen]

how can i address a letter to "John Smith, MD" and and create a greeting for
"Dear Dr. Smith:". I can not make the 2 things happen at the same time, I can
make either one happen but not both. I am mergeing from access and I have all
the fields set up to do this. I have tried selecting the fields and not using
address but I must not be doing it right......

[Graham Mayor]

Don't use the addressblock field.
Do you have separate fields that contain FirstName, LastName, Suffix, and
Salutation? If not you cannot derive them using parts of fields. You *may*
be able to derive them using conditional fields, but much depends on what
information is in your data records.
If you have the full information, it is simply a matter of inserting the
correct fields eg
{Mergefield FirstName} {Mergefield LastName}{If {Mergefield Suffix} "" ",
{Mergefield Suffix}"}
and
Dear {IF {Mergefield Title} "" "{Mergefield Title} {Mergefield LastName}"
"Sir/Madam"}
All brackets {} are inserted with CTRL+F9 and the fieldnames must be exactly
the names in your data file.

--

Graham Mayor - Word MVP

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


Ellen wrote:
how can i address a letter to "John Smith, MD" and and create a
greeting for "Dear Dr. Smith:". I can not make the 2 things happen at
the same time, I can make either one happen but not both. I am
mergeing from access and I have all the fields set up to do this. I
have tried selecting the fields and not using address but I must not
be doing it right......

[Graham Mayor]

Oops! I have used Title and Salutation to convey the same thing. The second
example should have read

Dear {IF {Mergefield Salutation} "" "{Mergefield Salutation} {Mergefield
LastName}"
"Sir/Madam"}

--

Graham Mayor - Word MVP

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


Graham Mayor wrote:
Don't use the addressblock field.
Do you have separate fields that contain FirstName, LastName, Suffix,
and Salutation? If not you cannot derive them using parts of fields.
You *may* be able to derive them using conditional fields, but much
depends on what information is in your data records.
If you have the full information, it is simply a matter of inserting
the correct fields eg
{Mergefield FirstName} {Mergefield LastName}{If {Mergefield Suffix}
"" ", {Mergefield Suffix}"}
and
Dear {IF {Mergefield Title} "" "{Mergefield Title} {Mergefield
LastName}" "Sir/Madam"}
All brackets {} are inserted with CTRL+F9 and the fieldnames must be
exactly the names in your data file.


Ellen wrote:
how can i address a letter to "John Smith, MD" and and create a
greeting for "Dear Dr. Smith:". I can not make the 2 things happen at
the same time, I can make either one happen but not both. I am
mergeing from access and I have all the fields set up to do this. I
have tried selecting the fields and not using address but I must not
be doing it right......