[Graham Mayor]

You cannot paste fields. Fields brackets {} must be inserted with CTRL+F9

--

Graham Mayor - Word MVP

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


Christine wrote:
Thank you, Rich. I've tried this but it won't work. I've evidently got
something wrong. I copied your formula exactly, except I changed the
field name to Cell which is the fieldname in the table. Then I pasted
the formula into the merge doc after the field 'Cell'. Actually, I
tried a number of variations of placement but didn't get anywhere.
Can you tell me where I insert the formula exactly?

Thank you,
Christine

"Rich/rerat" wrote:

Christine,
Try inserting the following, if you are using a field called
"cellphone".

{if{Mergefield cellphone}"" {Mergefield cellphone} \b "Cellphone:
" ""} Make sure you add a space after the colon ( and the quote
marks (")

Remember you need insert the field, you cannot just type "{}".

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate


"Christine" wrote in message
...
I'm not sure I've been able to find my exact situation so I hope I'm
not duplicating questions. I've seen some solutions that seem close
to what I'm looking for but they look much more complicated than
what I think I need.

Here is the problem. I have a Word main merge document with the
following text relating to client phone numbers:
Home:
Cell:
Work:

The phone number source info is from an Access database. In many
cases, I don't have all of the client's phone numbers and if a
number does not exist I
would like the line to disappear. For example, I want this appearance

Home: 555-5555
Work: 555-1111

when I don't have a cell number.

Is there a simple way to do this?

Thanks for your help.