View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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