It depends on what you have been left with, but I suggest you try the
following:
Have a look at Graham Mayor's article on
http://www.gmayor.dsl.pipex.com/convert_labels_into_mail_merge.htm
If you can follow that successfully (you probably only need to get to the
point where he has tab-separated address elements) then yu should be able to
select thedata and copy/paste it into an Excel worksheet.
However, the chances are that your Excel sheet had a column for street, a
column for city, a column for zip (if you're in the US) and so on, and this
process doesn't quite get you that far. If you have addresses in a standard
US layout and have done the "convert the table to text step in Graham's
article, you might look at the following sequence of find/replace operations
and try to modify them to suit your data:
First, you need to uncheck
Tools|AutoCorrect|"AutoFormat as you Type"|"Replace as you type"|"Straight
quotes with smart quotes"
and
Tools|AutoCorrect|AutoFormat|"Replace as you type"|"Straight quotes with
smart quotes"
Then, you need to make sure all the lines end in the same character (I use a
paragraph mark here). If they end in line feeds, do a replace of ^l by ^p.
In the Find/Replace dialog box, check the Wildcard option then do the
following finds/replaces, where the first line of each pair goes inthe Find
What and the second goes in the Replace With box.
^13([!,^13]@),([!0-9]@)([0-9]@)^13^13
^p\1^p\2^p\3^p¬^p
@^13
^p
,^13
^p
^13 @
^p
^13
",^p"
,^13"¬",
nothing
,^13
,
--
Peter Jamieson - Word MVP
Convert labels back to an Excel file said:
I produced a lengthy list of labels from a (large) Excel file which I then
erroneously lost and erased without backup (dumb move).
