Sending a group email

N

Newbee

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

Newbee

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?
 
G

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
 
N

Newbee

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

Newbee

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.
 
R

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Outlook 2007 contact list without losing groups 0
Automatic Emails sent to my Contact Groups by Microsoft 1
Change the "From" email address VBA 0
Can't send emails on new PC 1
Office 365 Email Encryption One time Passcode 0
Have 4 email addresses Want to auto forward all in one of them 0
Outlook 365 Signatures 0
Mail Merge file containing a Word Table 0

Top