Sorting labels by color letter

M

Mariela

I have document with labels. Each lable have text and one of the words
contains red letter. I need to sort labels by that red letter.

How can I do this?
 
J

Jay Freedman

This very much depends on how the labels are separated from one another in
the current document. Are they in a table, with one cell per label, like
what you get from the Tools > Envelopes and Labels wizard? If so, how many
columns are in the table, and are all the columns filled with labels or are
some columns used as spacers? If they aren't in a table, is there one blank
paragraph mark between labels, or possibly more than one, or some other
scheme?

The general idea is to make a table with exactly two columns: the labels are
all in one column (at least temporarily), and the other column is empty.
Then your macro searches the label column for text in red font color. Each
time it finds text, it makes a copy of it in the other column of the same
row. When that's complete, the macro sorts the table on the column
containing only the copy of the red text. Finally, it deletes that column,
and if necessary it reformats the table into multiple columns.

None of that can begin until we know what the original format is...
 
M

Mariela

Hi Jay,

Thanks for the help.

The lables are 4 columns and 12 rows. No space between colums and a little
in the end after the last row. All colums are filled and made in table.
I don't know if the lables are made by wizard I just can speculate that they
are. At least it's look like they are.



Mariela
 

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

Top