Sending a group email

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to send a group email from email addresses I have listed in my
spreadsheet. How do I do it?
 
Newbee said:
I want to send a group email from email addresses I have listed in my
spreadsheet. How do I do it?
Click to expand...


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
 
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.
 
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
 
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?
 
Back
Top