Another line suppression issue in Word 2007

O

Oldsfan

Guys,

You really helped me out with my last blank line suppression question. I
was able to fix all of my label files, as well as some issues I was having in
a mail merge directory. Now, I have one last issue I would like to fix with
the directory. Maybe I can't do it. This directory includes names,
addresses, phone numbers, email addresses and owned vehicles. I have been
able to successfully suppress the blank lines for Address2, Country, Home
Phone and Email. The last line for each listing is a vehicle. Not all
people in the directory have vehicles. I need to suppress this blank line
and have it go to the next listing, like I've shown below:

Smith, James R. (#5767)
1122 S. Muir
Anytown, KS 00000
555-555-1212
(e-mail address removed)
1929 F-29 Six 4-door Sedan
Smith, John (#316)
2211 Silver Cedar Rd
Anytown, WI 00000-1111
555-555-1212
(e-mail address removed)

Smith, Richard C. (#5650)
1010 S Chestnut
Anytown, KS 00000
555-555-1212
(e-mail address removed)

Smith, Ron G. (#623)
N1234 Hwy J
Anytown, WI 00000

Do you understand what I'm trying to do? I need to not have a gap between
entries, like the first two, not like the 2nd, 3rd and 4th entries. I've got
about 1300 entries, so I can't go in and edit out each line indiviually. To
compound the problem, this last line has three data fields:

<Year> <Model> <Body Style>

Is this possible?

Thanks in advance,

Paul
 
G

Graham Mayor

It helps people know what you are talking about if you keep to the same
thread, however, what you ask is straightforward

{Mergefield Email}{IF {Mergefield Model} <> "" "[enter]
{Mergefield Year} {Mergefield Model} {Mergefield "Body Style"}"}[enter]

If you have extra space between the entries check that you only have one
paragraph mark at the end of each line, or that there is no spacing added
before/after the paragraph.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
O

Oldsfan

Thanks, Graham. I started another thread because I thought this was a
different kind of issue, but now that I look at is, I guess it's not, really.
I'll try your solution when I get home. I think I see where I went wrong.

Thanks again for your help. It is greatly appreciated. This has saved me
from so much manual editing, and I'm just a little bit too dumb to figure
this stuff out on my own.

Paul

Graham Mayor said:
It helps people know what you are talking about if you keep to the same
thread, however, what you ask is straightforward

{Mergefield Email}{IF {Mergefield Model} <> "" "[enter]
{Mergefield Year} {Mergefield Model} {Mergefield "Body Style"}"}[enter]

If you have extra space between the entries check that you only have one
paragraph mark at the end of each line, or that there is no spacing added
before/after the paragraph.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Guys,

You really helped me out with my last blank line suppression
question. I was able to fix all of my label files, as well as some
issues I was having in a mail merge directory. Now, I have one last
issue I would like to fix with the directory. Maybe I can't do it.
This directory includes names, addresses, phone numbers, email
addresses and owned vehicles. I have been able to successfully
suppress the blank lines for Address2, Country, Home Phone and
Email. The last line for each listing is a vehicle. Not all people
in the directory have vehicles. I need to suppress this blank line
and have it go to the next listing, like I've shown below:

Smith, James R. (#5767)
1122 S. Muir
Anytown, KS 00000
555-555-1212
(e-mail address removed)
1929 F-29 Six 4-door Sedan
Smith, John (#316)
2211 Silver Cedar Rd
Anytown, WI 00000-1111
555-555-1212
(e-mail address removed)

Smith, Richard C. (#5650)
1010 S Chestnut
Anytown, KS 00000
555-555-1212
(e-mail address removed)

Smith, Ron G. (#623)
N1234 Hwy J
Anytown, WI 00000

Do you understand what I'm trying to do? I need to not have a gap
between entries, like the first two, not like the 2nd, 3rd and 4th
entries. I've got about 1300 entries, so I can't go in and edit out
each line indiviually. To compound the problem, this last line has
three data fields:

<Year> <Model> <Body Style>

Is this possible?

Thanks in advance,

Paul
Click to expand...
Click to expand...
 

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

Similar Threads

Word 2007 Label Mail Merge Suppression Issue 3
Suppressing a line in a form 1
trying to get Word tables into Publisher 3
Who could solve this bug (in my balanced line) 1

Top