Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / March 2005

Tip: Looking for answers? Try searching our database.

Sorting labels by color letter

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mariela - 09 Mar 2005 16:39 GMT
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?
Mariela - 09 Mar 2005 16:59 GMT
By the way I'm using Word 2003 and I meant alphabetically sorting.

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?
Jay Freedman - 09 Mar 2005 19:39 GMT
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...

Signature

Regards,
Jay Freedman
Microsoft Word MVP          FAQ: http://word.mvps.org

> By the way I'm using Word 2003 and I meant alphabetically sorting.
>
[quoted text clipped - 4 lines]
>>
>> How can I do this?
Mariela - 09 Mar 2005 21:01 GMT
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

> 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
[quoted text clipped - 22 lines]
> >>
> >> How can I do this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.