Removing blanks from and cocantening labels

[RogerJ]

I have created label layouts from a found set of referrals. The membership form can have up to 4 referrals. I have 4 label layouts, but not all membership forms have 4 referrals (Clear so far?) For those that have only 1 referrals, the label layout works fine. But, if the referrals are >1 then the label layouts have blank spaces in them. What I would like to do is to:

1) remove all blank spaces from label layouts 2 thru 4

2) cocantenate the 4 label layouts into one (if possible)

3) print the labels

Currently there are 39 records in the found set, with 74 referrals. Most have only 1, a few have 2, a few have 3 and only a couple have 4.

Any suggestions as to how to accomplish this with a script would be helpful.

TIA

[Lee Smith]

This seems like a duplicate post. If my answer to the other one doesn't work on this, then let us know what you are trying to do, and what is happening.

BTW, if this is a double post, please do not do that.

Lee

[RogerJ]

Thanks for the response on both messages Lee. I did not intend this to be a double post, although I will agree that the 1) above is basically the same as my other message. However, 2) is totally different and was not addressed. I thought they were different enough to warrant a seperate message instead of including them as one. Guess I will know next time to include ALL problems in one message. If I did not make it clear what I am trying or want to do, let me know and I will try to rephrase it.

[Lee Smith]

Can you attach a copy of your files?

Lee

[RogerJ]

No Lee, I cannot attach the files. Because of information in the files which is private, I cannot attach or send them. Sorry.

I followed your instructions -- "Layout, Select Fields, Menu, Format Sliding/Printing, Select Option". I tried all possibilities or choices but none removed the blank labels. Don't want to remove blank spaces IN the labels, but the blank labels. Make sense?

Let me try again...

In looking at the layout in preview mode I have 30 labels 10 down by 3 across. If they are numbered across with 1 in the upper left corner and 30 in the lower right, I have label position 1 through 11 empty, an address in pos 12, pos 13 -16 empty, an address in 17, then 18-24 empty, an address in 25 and 26 through 30 empty. So there are 3 labels. Is it possible to remove empty lables 1-11, 13-16, 18 - 24 and 26-30 on this sheet. This is label layout 4. I have 2 other layouts that have basically the same thing with varying amounts of addresses and blank spaces. Is it possible to remove all the blank labels in these layouts, then cocantenate them into 1 layout so I don't waste labels?

Is that clearer? Sorry for the confusion.

[Lee Smith]

No Lee, I cannot attach the files. Because of information in the files which is private, I cannot attach or send them. Sorry.

That's too bad. It might have speeded up the process.

BTW, most of us do not include real data in the records when we post a file, or if we do, we substitute fake data for the confidential stuff.

In this case, the data wasn't important, I wanted to see what fields were being used in your label and why some did and some didn't have filled in data.

I followed your instructions -- "Layout, Select Fields, Menu, Format Sliding/Printing, Select Option". I tried all possibilities or choices but none removed the blank labels. Don't want to remove blank spaces IN the labels, but the blank labels. Make sense?

With this latest response, I don't think see this as a "Slide" field problem. But, instead think has to do with your [color:"red"]Found Set.

Let me try again...

In looking at the layout in preview mode I have 30 labels 10 down by 3 across. If they are numbered across with 1 in the upper left corner and 30 in the lower right, I have label position 1 through 11 empty, an address in pos 12, pos 13 -16 empty, an address in 17, then 18-24 empty, an address in 25 and 26 through 30 empty. So there are 3 labels. Is it possible to remove empty lables 1-11, 13-16, 18 - 24 and 26-30 on this sheet. This is label layout 4. I have 2 other layouts that have basically the same thing with varying amounts of addresses and blank spaces. Is it possible to remove all the blank labels in these layouts, then cocantenate them into 1 layout so I don't waste labels?

Is that clearer? Sorry for the confusion.

Yes. It seems you have "All Records" in your [color:"red"]Found Set. Have you used the [color:"red"] = (equal sign) and/or the [color:"red"] Omit Option to set up your labels before trying to print them?

HTH

Lee

[RogerJ]

Lee, I have (as previously stated) 39 records (of 120+) with 74 referrals. The label layout is leaving blank labels where there is no data. As an example: If record 1 has only 1 referral and record 2 has two, in label layout 1 (for the 1st set of addresses), it will have labels 1 and 2 with information. But, on label layout 2 (for the second set of addresses), label 1 with be blank, but label 2 will have the address. This is because the 1st record only has 1 referral address. To complicate this, there are 4 possible referral addresses. I have considered putting all the referrals on their own layout, but I was told they needed to be kept WITH the person submitting them.

Any other ideas?

[RogerJ]

Well, I got part of it figured out. I can now print labels without all the blank spaces. However, since I have 4 label layouts, is there a way to combine them into one with a script?

Thanks,

[Lee Smith]

Hi Roger,

I sent you a private message.

Lee