Mail merge fields

  • Thread starter Thread starter Lotto
  • Start date Start date
L

Lotto

I have an Acces DB that is merged to a directory listing af all
members of a group. I want this to suppress the blank records, as in
if it has three phone number fields, and the person only has one
listed, to just show the one. works fine until I try and place a
header in front. What else can I do with these?

See example:
501 West Governor Road
Hershey, PA 17033 USA
Home:
Office: +1 717-534-2082
Fax:
Email: (e-mail address removed);www.aacalibrary.org
 
I think you already identified your problem and solution. If there is no
data for a line, don't generate the line with the header (name and colon)
for that item.

Other comments: An Access _Database_ cannot be "merged". The example you
show does not have any blank lines. The ones that are giving you trouble, I
presume, only have a label with a colon (I think you are calling that a
"header"?).

I think you will have to provide detail and specific information about the
data you have, how you generate the mail merge list, and how and where you
use it if we are to be able to offer you specific help (other than my guess
above, based on what you wrote).
 
Back
Top