Sending a group email

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

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?

 

[Gord Dibben]

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

 

[Guest]

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

 

[Guest]

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]

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

 

[Guest]

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

 

[Rachel]

Hi,
Can I send a reminder email from an excel spreadsheet? for example if a
course date has expired for a contact, will excel send an individual email to
them? If so, how do I set it up please?

 

[Gord Dibben]

See Ron de Bruin's site for instructions and code on sending an email when a
cell reaches a defined value.

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


Gord Dibben MS Excel MVP