how do i convert MS Word mailing labels into an Excel mailing lis.
 

I have a Word mailing list (8 rows, 2 columns on each page) which I want to
convert to an Excel mailing list. I can paste it into the spreadsheet but I
want to avoid having to cut and paste all the addresses into the Excel
address fields. Is there any easy way of converting it?

It would depend on how the data is laid out.

If all the addresses were 8 rows with row 1 mapped to the same column, row 2 to
the next column, ..., row 8 to the 8th column, then either a macro or formulas
could be used.

If the number of rows varied, but there was an indicator (blank row between each
group), then that would be a different solution.



unrhyll wrote:

I have a Word mailing list (8 rows, 2 columns on each page) which I want to
convert to an Excel mailing list. I can paste it into the spreadsheet but I
want to avoid having to cut and paste all the addresses into the Excel
address fields. Is there any easy way of converting it?

--

Dave Peterson