suppressing blank fields when merging from excel

E

editor

I'm working in Word 2004 and Excel (2000 from a PC). I am creating an
alphabetical directory for my son's school. I have a number of fields
where there isn't always data (i.e., dad's cell #). In formatting my
main document, I want to have headings for these phone number data
that would identify what each phone number is, but I don't want to
have to manually eliminate those headings where there is no data for
the field. Is there programming that I can write that will allow me
to tell the merge that if the (field) is blank, don't print the
heading, or if the (field) has info, print the heading. In other
words, I want to print: Cell # (Dad): <cell_dad>, where <cell_dad>
has a number in it, and not print: Cell #(Dad): if <cell_dad> is
blank. In my head it seems simple, but I can't figure out how to do
it. Any help out there?
 
C

CyberTaz

Explore the Data Merge Manager palette in Word 2004 - especially the section
labeled "Word Fields" - You'll find exactly what you're looking for named
almost identically to the phrasing in your post: If...Then...Else... :)
You'll also find more info in Word Help as well as the following link:

http://word.mvps.org/faqs/MailMerge/index.htm

(If using Safari you may need to click the Reload button a few times, &
don't let the fact that it seems "PC-Oriented" put you off - most everything
translates directly enough to Mac Word.)

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 10/16/07 8:29 PM, in article
[email protected], "editor"

I'm working in Word 2004 and Excel (2000 from a PC). I am creating an
alphabetical directory for my son's school. I have a number of fields
where there isn't always data (i.e., dad's cell #). In formatting my
main document, I want to have headings for these phone number data
that would identify what each phone number is, but I don't want to
have to manually eliminate those headings where there is no data for
the field. Is there programming that I can write that will allow me
to tell the merge that if the (field) is blank, don't print the
heading, or if the (field) has info, print the heading. In other
words, I want to print: Cell # (Dad): <cell_dad>, where <cell_dad>
has a number in it, and not print: Cell #(Dad): if <cell_dad> is
blank. In my head it seems simple, but I can't figure out how to do
it. Any help out there?
 
Top