If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I organize labels on word?
I have about 5000 labels for a mailer I am putting together. I recieved them
in Word format. I believe that their are many duplicates. I would like to sort them so that I can remove them prior to using them. Pasting them into excel doesnt seem to work because it puts each line into a new cell and sorting them jumbles the info. Is there any hope for me? Please help. |
#2
|
|||
|
|||
How can I organize labels on word?
It is not clear exactly what you are starting with, but I suspect that it is
with a document in which the data for each label appears as you would have it on the label itself. If that is correct, see "Convert Labels into Mail Merge Data File" on fellow MVP Graham Mayor's website at: http://www.gmayor.com/convert_labels...mail_merge.htm That will then get the labels into a format where you can sort them. Then if you see the article "Finding and replacing characters using wildcards" at: http://www.word.mvps.org/FAQs/Genera...gWildcards.htm you will find a method of removing the duplicates. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP " .com wrote in message ... I have about 5000 labels for a mailer I am putting together. I recieved them in Word format. I believe that their are many duplicates. I would like to sort them so that I can remove them prior to using them. Pasting them into excel doesnt seem to work because it puts each line into a new cell and sorting them jumbles the info. Is there any hope for me? Please help. |
#3
|
|||
|
|||
How can I organize labels on word?
Thank you very much for your help. I followed your instruction and learned a
new trick - There were about 850 duplicates. Thanks again, Nick "Doug Robbins - Word MVP" wrote: It is not clear exactly what you are starting with, but I suspect that it is with a document in which the data for each label appears as you would have it on the label itself. If that is correct, see "Convert Labels into Mail Merge Data File" on fellow MVP Graham Mayor's website at: http://www.gmayor.com/convert_labels...mail_merge.htm That will then get the labels into a format where you can sort them. Then if you see the article "Finding and replacing characters using wildcards" at: http://www.word.mvps.org/FAQs/Genera...gWildcards.htm you will find a method of removing the duplicates. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP " .com wrote in message ... I have about 5000 labels for a mailer I am putting together. I recieved them in Word format. I believe that their are many duplicates. I would like to sort them so that I can remove them prior to using them. Pasting them into excel doesnt seem to work because it puts each line into a new cell and sorting them jumbles the info. Is there any hope for me? Please help. |
Thread Tools | |
Display Modes | |
|
|