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.