Sending a group email

I want to send a group email from email addresses I have listed in my
spreadsheet. How do I do it?

Newbee

With the help of some VBA code from Ron de Bruin.........

http://www.rondebruin.nl/mail/folder2/files.htm

Check out the "Index" on that site for more mailing code and a free SendMail
add-in.


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 07:31:09 -0800, Newbee <[email protected]>
wrote:

>I want to send a group email from email addresses I have listed in my
>spreadsheet. How do I do it?

"Newbee" wrote:

> I want to send a group email from email addresses I have listed in my
> spreadsheet. How do I do it?


Whats is vba and why do I have to go to another site. Are you saying that
after typing in all those emails in the cells that I can't use them without
some other support?

VBA is Visual Basic for Applications.

It is part of your MS Office application.

VBA is used to create code to assist Office applications with repetitive tasks
or tasks that cannot be be done natively.

Typing email addresses in your worksheet is just the start of your task.

Now you want to send a group email to those addresses on the list.

Excel cannot do this all on its own. Excel is quite dumb when it comes to
that type of operation.

I referred you to Ron's site because he has done all the work of coding.

With Excel closed..........

Download his SendMail add-in, stick it in your Office\Library then open your
workbook in Excel.

Go to Tools>Add-ins and checkmark the Sendmail add-in.

Depending upon what type of group email you want to send and what you will
send, the add-in will assist.


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 14:35:03 -0800, Newbee <[email protected]>
wrote:

>
>
>"Newbee" wrote:
>
>> I want to send a group email from email addresses I have listed in my
>> spreadsheet. How do I do it?
>
>
>Whats is vba and why do I have to go to another site. Are you saying that
>after typing in all those emails in the cells that I can't use them without
>some other support?

Thank you very much - I didn't realize what went into making this work. I
really appreciate your answer!!

Me again - It seems when I go to Rons site it is giving instructions on how
to send a worksheet by email. What I want to do is use the email addresses
and create a seperate email - I do not want to send info from excel. I want
to create a seperate email using the addresses in the data base.



"Gord Dibben" wrote:

> VBA is Visual Basic for Applications.
>
> It is part of your MS Office application.
>
> VBA is used to create code to assist Office applications with repetitive tasks
> or tasks that cannot be be done natively.
>
> Typing email addresses in your worksheet is just the start of your task.
>
> Now you want to send a group email to those addresses on the list.
>
> Excel cannot do this all on its own. Excel is quite dumb when it comes to
> that type of operation.
>
> I referred you to Ron's site because he has done all the work of coding.
>
> With Excel closed..........
>
> Download his SendMail add-in, stick it in your Office\Library then open your
> workbook in Excel.
>
> Go to Tools>Add-ins and checkmark the Sendmail add-in.
>
> Depending upon what type of group email you want to send and what you will
> send, the add-in will assist.
>
>
> Gord Dibben Excel MVP
>
> On Wed, 30 Mar 2005 14:35:03 -0800, Newbee <[email protected]>
> wrote:
>
> >
> >
> >"Newbee" wrote:
> >
> >> I want to send a group email from email addresses I have listed in my
> >> spreadsheet. How do I do it?
> >
> >
> >Whats is vba and why do I have to go to another site. Are you saying that
> >after typing in all those emails in the cells that I can't use them without
> >some other support?
>
>

Not familiar enough with Outlook and its ability to use a list in Excel to
create a group email without having the email addresses in my Address book to
start with.

This is how I would do it.................

Save the workbook with the addresses as a *.CSV file.

Then import that to Outlook address book into your Contacts folder.

Make a distribution list from these.

Group email from that distribution list.


Gord

On Thu, 31 Mar 2005 06:47:02 -0800, Newbee <[email protected]>
wrote:

>Me again - It seems when I go to Rons site it is giving instructions on how
>to send a worksheet by email. What I want to do is use the email addresses
>and create a seperate email - I do not want to send info from excel. I want
>to create a seperate email using the addresses in the data base.
>
>
>
>"Gord Dibben" wrote:
>
>> VBA is Visual Basic for Applications.
>>
>> It is part of your MS Office application.
>>
>> VBA is used to create code to assist Office applications with repetitive tasks
>> or tasks that cannot be be done natively.
>>
>> Typing email addresses in your worksheet is just the start of your task.
>>
>> Now you want to send a group email to those addresses on the list.
>>
>> Excel cannot do this all on its own. Excel is quite dumb when it comes to
>> that type of operation.
>>
>> I referred you to Ron's site because he has done all the work of coding.
>>
>> With Excel closed..........
>>
>> Download his SendMail add-in, stick it in your Office\Library then open your
>> workbook in Excel.
>>
>> Go to Tools>Add-ins and checkmark the Sendmail add-in.
>>
>> Depending upon what type of group email you want to send and what you will
>> send, the add-in will assist.
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Wed, 30 Mar 2005 14:35:03 -0800, Newbee <[email protected]>
>> wrote:
>>
>> >
>> >
>> >"Newbee" wrote:
>> >
>> >> I want to send a group email from email addresses I have listed in my
>> >> spreadsheet. How do I do it?
>> >
>> >
>> >Whats is vba and why do I have to go to another site. Are you saying that
>> >after typing in all those emails in the cells that I can't use them without
>> >some other support?
>>
>>

Thanks, that sounds logical - I will give it a try.