The subject of editing pre-prepared label documents comes up in the forums on a fairly regular basis. I have often referred such enquiries to my web page - Convert Word labels to a mail merge data source - which covers a complex, but nevertheless effective, method of extracting label contents to a word table that can be used as a mail merge data source.
Now I have revisited the issue and produced a simple to use Word add-in that extracts data from a named label document to an Excel worksheet.
The add-in is driven by a simple userform from a button on the add-ins Tab of the ribbon
The userform, after my standard disclaimer, is as follows:
A default name is pre-inserted into the form, but you may change that and of course you must add a location to save it.
You must also add a document to process, which can be the active document or another selected document. If you get it wrong, the process is extensively error trapped with informative messages to indicate the error.
At this point you can click 'Extract the labels to the workbook'
and the process will extract the data to as many fields as are required for the data in the labels. The fields are all called Field# where # is an incrementing number:
As the process can take a while to run, a progress indicator keeps track:
When the extraction is completed, the process wil attempt to save the workbook with the name and path selected on the userform. If a file of that name already exists, a prompt askes if you wish to overwrite the existing file. If you choose not to overwrite, the workbook is displayed, so that you may make your own choice of file name and save location.
Some years ago I prepared a web page Convert Word labels to a mail merge data source which describes how to extract the data from a pre-prepared label sheet, so that it may be extracted to a Word table for use as a Mail Merge data source.
This page builds on that process to extract data from a similar label sheet to an Excel worksheet, where again it may be easily edited and re-merged to labels.