I have an excel sheet that I'm printing a directory from. There are 4
fields at the end of the sheet that I would like printed out when the
mailmerge takes place.

However, what happens is that the mailmerge hangs up my computer for
some reason. The data structure is name & address info, with the final
4 fields being things like Family, Career, Awards and Remembrances. In
some cases, some of the fields would be submitted, some would not. For
instance, Person #1 may have nothing in those 4 fields, Person #2 may
have something in the last field. Person #3 would have something in
Fields 1, 2 and 4. Person # 4 would have something in all 4 fields.

The way it will "work" in the mailmerge is if I just have the fields
displayed in a list, like below:

Name
Address
* Family
* Career
* Awards
* Remembrances

What I want is to display a literal that is beside that field, if it is
there.

If person #2 has something in remembrances I'd like for it to be:

Person 2
Person2 Address
* Remembrances: some text about remembrances, etc.

where the literal "Remembrances:" is displayed there. I don't want
family, career and other displayed if the fields are blank.

Person #3 would be like:

Person 3
Person3 address
* Family: list family info
* Career: list career info
* Remembrances: list remembrances.

I've gone & edited the field and tried to put a literal there that would
display before the field, but the mailmerge hangs up on me, I am
guessing that it is doing it when there's nothing in that field.

Is there a way to do this to make it work so that if someone has filled
in only partial fields that the appropriate literal will display for
that entry?

Also, why is Mailmerge hanging up with me when I try to do this?

Thanks
BC

You should be using an If...then...Else field that checks if each field is
blank and inserts whatever you mean by "a literal" if that field is not
blank.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Blasting Cap" wrote in message
...
I have an excel sheet that I'm printing a directory from. There are 4
fields at the end of the sheet that I would like printed out when the
mailmerge takes place.

However, what happens is that the mailmerge hangs up my computer for some
reason. The data structure is name & address info, with the final 4
fields being things like Family, Career, Awards and Remembrances. In some
cases, some of the fields would be submitted, some would not. For
instance, Person #1 may have nothing in those 4 fields, Person #2 may have
something in the last field. Person #3 would have something in Fields 1,
2 and 4. Person # 4 would have something in all 4 fields.

The way it will "work" in the mailmerge is if I just have the fields
displayed in a list, like below:

Name
Address
* Family
* Career
* Awards
* Remembrances

What I want is to display a literal that is beside that field, if it is
there.

If person #2 has something in remembrances I'd like for it to be:

Person 2
Person2 Address
* Remembrances: some text about remembrances, etc.

where the literal "Remembrances:" is displayed there. I don't want
family, career and other displayed if the fields are blank.

Person #3 would be like:

Person 3
Person3 address
* Family: list family info
* Career: list career info
* Remembrances: list remembrances.

I've gone & edited the field and tried to put a literal there that would
display before the field, but the mailmerge hangs up on me, I am guessing
that it is doing it when there's nothing in that field.

Is there a way to do this to make it work so that if someone has filled in
only partial fields that the appropriate literal will display for that
entry?

Also, why is Mailmerge hanging up with me when I try to do this?

Thanks
BC

Doug Robbins wrote:
You should be using an If...then...Else field that checks if each field is
blank and inserts whatever you mean by "a literal" if that field is not
blank.


Would doing this leave a blank line there if there was nothing to put in
the field?

Currently, it bumps the filled in fields one under the other, without a
blank line for an unused field.

BC

No, it doesn't have to if you set up a nested If...then...Else field
construction with carriage return/new line characters in the appropriate
position in the true/false results of the fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Blasting Cap" wrote in message
...
Doug Robbins wrote:
You should be using an If...then...Else field that checks if each field
is blank and inserts whatever you mean by "a literal" if that field is
not blank.


Would doing this leave a blank line there if there was nothing to put in
the field?

Currently, it bumps the filled in fields one under the other, without a
blank line for an unused field.

BC