Copy Excel address book to Word for subsequent use with MSN Hotmai
 

Please tell me how to copy a one column email address book in Excel and paste
it into a Word file that I can subsequently copy into an email on MSN Hotmail
and send to colleagues. MSN Hotmail requires a comma after each email
address to send an address book. I am using Office 2000 programs.

Copy Excel address book to Word for subsequent use with MSN Hotmai
 

I'm not sure why you have to paste into MSWord.

If your list is in A1:A10 (say)
Insert a new column B and put this in B1:
=A1

Then put this in b2:
=B1&","&A2

And drag the formula in B2 down to B10.

Then you can pick up the single value in B10 and paste directly into your email
To: field.

Mike A. wrote:

Please tell me how to copy a one column email address book in Excel and paste
it into a Word file that I can subsequently copy into an email on MSN Hotmail
and send to colleagues. MSN Hotmail requires a comma after each email
address to send an address book. I am using Office 2000 programs.

--

Dave Peterson