Thread: Removing spaces
View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Rich/rerat Rich/rerat is offline
external usenet poster
 
Posts: 93
Default Removing spaces

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.