Christine,
Sorry I gave you the wrong information.
In the word document, Set up the merge for a directory, use Access as you
database.
Insert the fields for:
Name
Home
Cell
Work
Now Right click each phone field Select Toggle Field Codes, and add the
following switch:
\b "FieldName: "
So you will have the following in your document:
Name
{Mergefield Home \b "Home: "}
{Mergefield Cell \b "Cell: "}
{Mergefield Work \b "Work: "}
Space (This will separate each Record when the Merge is finished)
Space
Then Merge to New Document
--
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
...
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
"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.