Can anyone help me to get rid of blank lines when printing out labels. I have used setup to enable sliding/printing upwards but it doesn't seem to make any difference when I print the labels as there are still blank lines in the addresses.

Please help!!!!

Layout Mode / Format / Sliding-Printing

If they are blank lines from somebody pressing the return key in the field, sliding/printing won't get rid of them. You need to edit the data.

Blank lines have tricked me in the past...

I once experienced on printing labels on a Windows machine that there occured blank lines in an address field where there was absolutely no error to find. On mac it was ok. I do not remember if it were merge fields or 'normal' fields.

But most likely it is a Return problem, as said. When you have address fields you let it show one line, and if for example a street name is closed with a return, (and after that TAB or ENTER) you don't see that, only when you click on the field.

When this kind of input-inconsistency often occurs (multiple newbie users..) it might be an idea to write some kind of consistency script, checking the fields that normally do not have returns in them, for returns.

Harryk

I apologize for my earlier post. I was having one of those days when I just misread things and was not paying a lot of attention to things. An entire day of senior moments.

If the problem is because of users entering extra blank lines (by hitting the return key), you can just do substitute(whateverField, "

No need to apologise: I thought your answer was good. I just posted a "Plan B" answer...