Leave no space if line is blank in mail merge address.

[KarenABS]

I have some recipients that have 2 lines of address but most have only 1
line. How do I get rid of the line of blank data instead of printing a blank
line?

 

[Ron Cohen]

Look on the print dialog screen for the option to skip blank lines.

 

[KarenABS]

Thanks so much.

Look on the print dialog screen for the option to skip blank lines.

 

[me04984]

Could someone please explain to me where this option to skip blank lines is?
When I go to print and the little options box comes up, there is no choice to
opt out of printing blank lines. I am using Publisher 2003. I also looked on
the Advanced options. Where else could it be? What else can I do?

thanks.

 

[Rob Giordano \(Crash\)]

I usually filter them out in Excel before I do a mail merge.

--

Rob Giordano
Microsoft MVP - FrontPage





| Could someone please explain to me where this option to skip blank lines
is?
| When I go to print and the little options box comes up, there is no choice
to
| opt out of printing blank lines. I am using Publisher 2003. I also looked
on
| the Advanced options. Where else could it be? What else can I do?
|
| thanks.
|
| "KarenABS" wrote:
|
| > Thanks so much.
| >
| > "Ron Cohen" wrote:
| >
| > > Look on the print dialog screen for the option to skip blank lines.
| > > --
| > > Ron
| > >
| > > | > > >I have some recipients that have 2 lines of address but most have
only 1
| > > > line. How do I get rid of the line of blank data instead of
printing a
| > > > blank
| > > > line?
| > >
| > >
| > >

 

[me04984]

how can you do that when some of them are four lines and some are five and
you want to keep them in alphabetical order?

 

[Rob Giordano \(Crash\)]

If you sort alpha since there's nothing in a blank line...it kinda
disappears..actually they probably go to the bottom of the table.

--

Rob Giordano
Microsoft MVP - FrontPage





| how can you do that when some of them are four lines and some are five and
| you want to keep them in alphabetical order?
|
| "Rob Giordano (Crash)" wrote:
|
| > I usually filter them out in Excel before I do a mail merge.
| >
| > --
| >
| > Rob Giordano
| > Microsoft MVP - FrontPage
| >
| >
| >
| >
| >
| > | > | Could someone please explain to me where this option to skip blank
lines
| > is?
| > | When I go to print and the little options box comes up, there is no
choice
| > to
| > | opt out of printing blank lines. I am using Publisher 2003. I also
looked
| > on
| > | the Advanced options. Where else could it be? What else can I do?
| > |
| > | thanks.
| > |
| > | "KarenABS" wrote:
| > |
| > | > Thanks so much.
| > | >
| > | > "Ron Cohen" wrote:
| > | >
| > | > > Look on the print dialog screen for the option to skip blank
lines.
| > | > > --
| > | > > Ron
| > | > >
| > | > > | > | > > >I have some recipients that have 2 lines of address but most have
| > only 1
| > | > > > line. How do I get rid of the line of blank data instead of
| > printing a
| > | > > > blank
| > | > > > line?
| > | > >
| > | > >
| > | > >
| >
| >
| >

 

[Ed Bennett]

If you sort alpha since there's nothing in a blank line...it kinda
disappears..actually they probably go to the bottom of the table.

No, if a particular field for a particular record is blank, then there
will be a blank line in the merged publication (not an entire blank entry).

For example, if I have a database like

Field1 Field2 Field3 Field4 Field5
ABC DEF GHI JKL MNO
123 456 789 ?!%

And I have a merge form as
<<Field1>>
<<Field2>>
<<Field3>>
<<Field4>>
<<Field5>>

Then I'd get
ABC
DEF
GHI
JKL
MNO

for the first record, and

123
456

789
?!%

for the second record.
What me04984 is asking is how to remove the blank line from the merged
data to get

123
456
789
?!%

Sorting the data will not do this. The Suppress Blank Lines option should.

 

[Rob Giordano \(Crash\)]

What I meant was;

Name Address City State Phone
Joe Smith 1234 St Anywhere NY 123456
Mary Jones xxxx Anywho AZ 333666
Blank Line
Hazel Jinx 2345 Way Overthere MD 3648555

If you sort on Name the Blank line disappears
Then you do your mail merge

My fault here is she wants to get rid of one of the column entries...second
address being blank...sooo the above wouldn't work.
My bad.


--

Rob Giordano
Microsoft MVP - FrontPage





| Rob Giordano (Crash) wrote:
| > If you sort alpha since there's nothing in a blank line...it kinda
| > disappears..actually they probably go to the bottom of the table.
|
| No, if a particular field for a particular record is blank, then there
| will be a blank line in the merged publication (not an entire blank
entry).
|
| For example, if I have a database like
|
| Field1 Field2 Field3 Field4 Field5
| ABC DEF GHI JKL MNO
| 123 456 789 ?!%
|
| And I have a merge form as
| <<Field1>>
| <<Field2>>
| <<Field3>>
| <<Field4>>
| <<Field5>>
|
| Then I'd get
| ABC
| DEF
| GHI
| JKL
| MNO
|
| for the first record, and
|
| 123
| 456
|
| 789
| ?!%
|
| for the second record.
| What me04984 is asking is how to remove the blank line from the merged
| data to get
|
| 123
| 456
| 789
| ?!%
|
| Sorting the data will not do this. The Suppress Blank Lines option should.
|
| --
| Ed Bennett - MVP Microsoft Publisher
| http://ed.mvps.org