| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you set up a simple address book in Excel | Excel Worksheet Functions | |||
| Address book to excel | Excel Discussion (Misc queries) | |||
| How do I create an address book in excel? | New Users to Excel | |||
| excel as address book | Excel Discussion (Misc queries) | |||
| How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
Hybrid Mode
