Hi =?Utf-8?B?RHJUb21pblJJ?=,
> I am using an access DB to create a merged word Document, sending letters to
> other colleagues. I have it set up fine if I know the recipeints last name
[quoted text clipped - 5 lines]
> I have the Insert before or after if not blank thing down, but the preformed
> wizard that comes up with the genereic <<greeting line>> is not what I want
Is this alternate form of address something you have stored in a look-up table,
and can bring into the data source via a query? If yes, then you can set up an
IF field in the mail merge that looks something like
Dear { IF { Mergefield Name } = "" "{ Mergefield AltAddress }" "{ Mergefield
Name }" }
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
Graham Mayor - 20 Dec 2005 06:35 GMT
Or if the alternative is not in the data file you could test the missing
field as suggested by Cindy and insert the following construction:
Dear {IF{Mergefield name} <> "" "{Mergefield Name}" "Colleague" }
Use CTRL+F9 to insert the field boundaries {}
You may find http://www.gmayor.com/formatting_word_fields.htm useful.

Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Cindy M -WordMVP- wrote:
> Hi =?Utf-8?B?RHJUb21pblJJ?=,
>
[quoted text clipped - 25 lines]
> This reply is posted in the Newsgroup; please post any follow
> question or reply in the newsgroup and not by e-mail :-)