View Single Post
 
Old 03-13-2015, 12:05 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

There is no shortcut to this while the document is in this pseudo label format. My guess is that the PDF conversion didn't convert to a table but to a dreadful mish-mash of text boxes or frames to retain the original formatting. You need to get that document into a table and then that table into Excel where you can use Excel tools to manipulate the data and remove duplicates, then mail merge back to labels.

Don't think of this as a label issue. Think of it as a data extraction issue.

If you want to send me a single page (change the names to preserve anonimity of the people involved) and I will see what is possible. In the meantime take a look at http://www.gmayor.com/convert_labels...mail_merge.htm

Send it as a mail attachment to supportATgmayor.com (change AT to @) and put your forum username in the subject or it will be discarded.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote