How to Send Emails from an Excel Spreadsheet Using VBA Scripts

To send emails from Microsoft Excel only requires a few simple scripts. Add this functionality to your spreadsheets and you can really enhance how much you can accomplish in Excel.

[derryckbartlett]

I get the compile error:  "Variable not defined" for the:  Set CDO_Mail = CreateObject("CDO.Message"), line?

[adriennkanto]

Thank you for the video. I would have a question:
Would it be possible to "just" generate the email from excel by clicking the command button which will generate the email in outlook? My list of the recipient is changes very often, therefore I prefer to see the generated email in outlook first, then I can send it manually.
Many thanks for your advice,
Bests,
Adrienn

[manjunathvinod]

How to extract data from Outlook webmail particular folder to excel using Excel VBA. Please help on this. Thanks in advance.

[santuycrypto]

how if i want to send the different payslip from excel to the mailing list?. thank you

[hugotavares]

it worked perfectly. How can I add a pdf file as attachment?

[BIGGOODBOY]

I don’t know what my smtp server is. I use outlook at work but not a website it’s on my desktop

[richardphatthenguyen]

Hi, your tutorial did work with SSL authentication. What does one need to change in order to deal with STARTTLS?

[Ismailpleash]

Can I use this code using Gmail?? or this only works with outlook?

[keesvandorsten]

Sadly doesn't work on 64-bit excel. Doesn't seem to be able to connect to server.

[killertctma]

what if you want it to send a range of information not just one individual cell? A more complicated question (if even possible), Is there a way to set up a method to take a range of data (cells A1:F150:) and have it copied and pasted to a new workbook then have that workbook it just created sent out into the email as an attachment (basically it would have to copy and paste then save to a new workbook while inputting that new workbooks file path into the strBody portion of this code)?


UPDATE: i figured it out but having problems with having it send an attachment. maybe someone can help me out. here's what i have "strBody = C:\Users\tabor\Documents\ & WBname & .xlsx" with & WBname being a public variable set to name the document that it saves in another module that pulls the sheet name + today's date.

[alassailcompany]

Thanks a lot for this video tutorial. I want to send the workbook or worksheet using VBA. Can you plz help me. I will be very thank you for that.

[elmerbanez]

i tried the script and it keeps giving me an error on send using - The "SendUsing" configuration value is invalid.