Email Addresses in an Excel Spreadsheet

[poochie]

I received a Excel Spread sheet from an external source. In it there is a column labeled as Email Addresses which consists of 100 email addresses. I would like to send a newsflash to 50 of these email addresses using Outlook. I can only send the news flash one at a time and this is very painful. Using the Spread sheet and Outlook is there a way to send the newsflash to the selected email addresses (50)?

Your help is kindly appreciated.

 

[VulcanJedi]

one approach is this, you could IMPORT the addresses into your contacts folder (or make a new sub folder in teh contacts) in Outlook. Then you could click on whoever and as many people you want. Then erase the folder after if you wish Tranpkp
************************************
- Let me know if this helped/worked!
Please remember to give helpful posts the stars they deserve!
This facilitates others navigating through the threads / posts!

 

[poochie]

Hi Tranpkp! I've tried to perform the IMPORT the addresses into your contacts folder and received the following Error message " An error has occured in the Microsoft Excel translator while getting the contents of a file system. Use Microsoft Excel to name the range of data you want to export". Would you know how to do this?

Regards 05/11/02

 

[ElijahBaley]

You need to name the range of data in the Excel worksheet that you want to import, so in Excel highlight the range of data that you want and select the 'insert' menu - select 'name' and then 'define' - you see that your highlighted range is selected just give it a name "emaillist" or whatever, then when you import into Outlook just select the 'named range' that you just created.

I would suggest that you create a temporary sub folder to import these into, away from you main contacts.

EB