Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Emails in Excel format, need to send out a mass email from list

I have a excel spread sheet that has many email addresses listed. I need to
find a way to be able to take those email address' and put them into a email
that is going out to a club of over 100 people. How can I do this? Is excel
not a good way of storing this ino? I will be using this email list often. I
am recieving it from another person. Thank you for any info that will help
with this.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Emails in Excel format, need to send out a mass email from list

What are you emailing to the addressees?

If not emailing an Excel workbook or worksheet it may be easier to import
all the addresses into your email client contacts and create a group list
there.

See how to do the import into Outlook Contacts at Ron de Bruin's site.

http://www.rondebruin.nl/mail/importcontacts.htm

If emailing a workbook to the addressees then..................

Everything you need to send emails from Excel can be found at Ron de Bruin's
site.

http://www.rondebruin.nl/sendmail.htm

Note the SendMail add-in which makes it all easy without writing your own
code.


Gord Dibben MS Excel MVP

On Tue, 16 Jun 2009 15:01:01 -0700, Sunrhyse
wrote:

I have a excel spread sheet that has many email addresses listed. I need to
find a way to be able to take those email address' and put them into a email
that is going out to a club of over 100 people. How can I do this? Is excel
not a good way of storing this ino? I will be using this email list often. I
am recieving it from another person. Thank you for any info that will help
with this.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 199
Default Emails in Excel format, need to send out a mass email from list

"Sunrhyse" wrote in message
...
I have a excel spread sheet that has many email addresses listed. I need to
find a way to be able to take those email address' and put them into a
email
that is going out to a club of over 100 people. How can I do this? Is
excel
not a good way of storing this ino? I will be using this email list often.
I
am recieving it from another person. Thank you for any info that will help
with this.


I have to do this fairly often and all I do is simply select the cells with
the required email addresses, then copy and paste them in to the appropriate
email address window - I usually use the bcc one for obvious reasons.
Clicking on the 'Check Names' button confirms they have been correctly
recognised by the email programme you are using.

Is there something preventing you doing this as I suspect you would have
tried it before posting this question...?

V

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel send emails jc132568 Excel Worksheet Functions 1 September 22nd 08 09:24 PM
how do I create email list from individual emails in Excel cells? Matt W Excel Discussion (Misc queries) 2 January 26th 08 09:53 AM
How to send email to a list of people in excel sheet? David Excel Discussion (Misc queries) 1 December 14th 06 01:46 AM
Send an email to a list of emails in a worksheet cexarsiado New Users to Excel 2 August 22nd 06 03:04 PM
Email addresses in Excel need to format for mass email Boomer Excel Worksheet Functions 1 June 9th 06 01:46 PM


All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"