Mailing Labels to Spreadsheet.

[J. Michael]

I have seen this question before but am unable to find the message.

I have a MS Word document in address label format. I would like
to convert this file to a spread sheet. How do I do this?

Thanks

Michael

 

[Eva]

Copy and paste in Ms Excel
Eva

 

[David McRitchie]

That's a start but you then have to put each line into a column.

See
Text to Columns, Split at LF (line=feed character) (#lf)
where each label is in one cell (macro in the topic after #lf)
http://www.mvps.org/dmcritchie/excel/snakecol.htm#lf

Creating a Table from something like a column of address labels (#snkAddr)
where there is a definite number of rows per label
http://www.mvps.org/dmcritchie/excel/snakecol.htm#snkAddr
macro code in
http://www.mvps.org/dmcritchie/excel/code/naddr3ss.txt

to install and use a macro see
http://www.mvps.org/dmcritchie/excel/getstarted.htm#havemacro