Word Form Letter - If - then statements

I have created a form letter that pulls information from a loca
database and populates the letter. However, I can't figure out how t
insert an if-then statement. Example: The letter reads "Dea
<<Borrower>>, <<CoBorrower>>"

Instead of the comma seperating the two I would like the form to inser
the word "and" IF the CoBorrower exists and leave it blank if th
CoBorrower does not exist.

Can anyone help me with this?

Thank you

--
Message posted from http://www.ExcelForum.com

Suzanne
Wed Nov 03 08:48:41 CST 2004

I expect you'll get an answer here. If not, you might try posting to the
newsgroup intended for mail merge questions,
microsoft.public.word.mailmerge.fields.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"tikitorch6 >" <<tikitorch6.1f3vj8@excelforum-nospam.com> wrote in message
news:tikitorch6.1f3vj8@excelforum-nospam.com...
> I have created a form letter that pulls information from a local
> database and populates the letter. However, I can't figure out how to
> insert an if-then statement. Example: The letter reads "Dear
> <<Borrower>>, <<CoBorrower>>"
>
> Instead of the comma seperating the two I would like the form to insert
> the word "and" IF the CoBorrower exists and leave it blank if the
> CoBorrower does not exist.
>
> Can anyone help me with this?
>
> Thank you!
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Graham
Wed Nov 03 09:47:17 CST 2004

Insert the fields manually using CTRL+F9 to set each pair of field
boundaries {}
Then you'll need something along the lines of

Dear {Mergefield Borrower}{IF {Mergefield CoBorrower} <> "" " and
{Mergefield CoBorrower}"}
Toggle the display with ALT+F9 to show the result.

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

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



> I have created a form letter that pulls information from a local
> database and populates the letter. However, I can't figure out how to
> insert an if-then statement. Example: The letter reads "Dear
> <<Borrower>>, <<CoBorrower>>"
>
> Instead of the comma seperating the two I would like the form to
> insert the word "and" IF the CoBorrower exists and leave it blank if
> the CoBorrower does not exist.
>
> Can anyone help me with this?
>
> Thank you!
>
>
> ---
> Message posted from http://www.ExcelForum.com/

tikitorch6
Wed Nov 03 14:48:21 CST 2004

Can anybody help me with this or let me know if it is possible?
Thank you

--
Message posted from http://www.ExcelForum.com

macropod
Thu Nov 04 05:53:07 CST 2004

Graham already did!


"tikitorch6 >" <<tikitorch6.1f5xij@excelforum-nospam.com> wrote in message
news:tikitorch6.1f5xij@excelforum-nospam.com...
> Can anybody help me with this or let me know if it is possible?
> Thank you!
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.778 / Virus Database: 525 - Release Date: 15/10/2004