Mail merge fields

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
 
A

Access Developer

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top