[D]

I have a mailing list in Word that I would like to put into one of my Excel
workbook sheets.
I am not sure how to do this can anyone help?
Thanks

[Dawn Crosier, MVP]

The answer to your question has many possibilities. For instance, if your
mailing list consists of a table in Word where all the names are in one
column, all the addresses' are in the second, and the city, state and zip
code are also in their own separate columns, then you can copy the table and
paste it directly into Excel. However if your mailing list consists of each
item in the mailing in a separate line, then I would do some things in Word
before transferring into Excel.

For instance, I would separate each address (mailing label) with a blank row
(extra paragraph marker)
If most of my addresses were only three paragraphs, but I had a few which
were four, I'd fix them so that they are all three or four line addresses.
(In other words make sure they all are the same number of lines)

I'd find and replace all double paragraphs (^p^p) with some character (~~)
which is not found in the addresses. Then I'd do a find and replace all
paragraphs (^p) in the list with tabs (^t). I'd now find all the special
characters(~~) and replace them with paragraphs(^p). And then I would
convert the text into a table. And finally, I would now copy this table
into Excel.

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"

This message was posted to a newsgroup, Please post replies and questions
to the group so that others can learn as well.
"D" wrote in message
...
I have a mailing list in Word that I would like to put into one of my Excel
workbook sheets.
I am not sure how to do this can anyone help?
Thanks