I am trying to cut a name and address from one source and then paste them
into excel to create a mailing list. I want to do a couple thousand names
so retyping them is not an option a want to explore. any ideas how I could
do this in excel or access??

I am trying to cut a name and address from one source and then paste
them into excel to create a mailing list. I want to do a couple
thousand names so retyping them is not an option a want to explore.
any ideas how I could do this in excel or access??

Knowing more about the source’s data format would help somebody respond to
your question.

Hi Nick,
For mailing labels see
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

To help you get your Excel file arranged properly with all of the
data to print a label coming from a row, see
http://www.mvps.org/dmcritchie/excel/snakecol.htm
Don't know if it will help you, but there are several examples
for different formats of data.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Nick" wrote in message ...
I am trying to cut a name and address from one source and then paste them
into excel to create a mailing list. I want to do a couple thousand names
so retyping them is not an option a want to explore. any ideas how I could
do this in excel or access??