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

G

Guest

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?
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I print mailing labels from an Excel file? 5
reverse mailing list? 2
Printing mailing labels 2
printing mailing labels when data is in rows 3
How to print labels from Excel2007 using Word2007 mail merge??? 1
Mailing Labels 2
How do I convert an Excel spreadsheet to mailing labels? 2
Convert an Excel file into mailing labels 1

Top