Send An Email From Your Gmail Account with VBA | Excel VBA Tutorial 

If you want to attach multiple attachment, you will need to insert another addAttachment statement. For example With newMail .Subject = "Hello World" .From = "sender Email" .To = "recipient Email" .CC = "" .BCC = "" .TextBody = "This is a test email." .AddAttachment "directory of file1" .AddAttachment "directory of file2" .AddAttachment "directory of file3" End With

... hahaha ... I'm giddy with excitement. Thank you!

Nice lesson, thanks for posting it! Can you show how to manipulate with different recepients?

thanks dude.!!! this was really amazing..

With this code is it possible to send 500 more E-mails, or would it be blocked by the provider if you exceed this limit?

thanks it really helped a lot

Thank you

Hi, very good! I have a question, how can I only prepare mail without send immediatly, and see themm in the gmail draft folder? Many thanks.

Thanks for the video. Is it true that this method will no longer be supported, but should be switched to OAuth 2.0? Do you know how to get started with this?

Can I use for loop to send the mail to different people

When my email id is wrong (i.e, not found in mail address book),the macro stops running. What can be done to prevent thia as this prevents from sending my others mails to users in the same column??

I got error: & err.description, vbinformation in my case, what can be wrong?

The transport failed to connect to the server, I am using gmail. Pleas help me. Using Excel 2016, 64 bits

Hi! Pretty good! I have a question, do you know how to put that image in the body of the email too?

Hi! Preety good! I have a question, how can I put that image in the body too?

I am getting the server response was not available error. Please Help

Hi.. I have more than one files to send to the same email id - One attachment per email. Can i loop through the files in the folder to send as per my expectations

Hi! I am getting this error when I try to run it. Automation error %1 is not a valid Win32 application.

Hello, Thank you for the tutorial. Also can you upload a vba tutorial on how to download attachment from Gmail in specific format and fill up the mail details in 1 excel macro file.

Hello there I always encounter this "The “SendUsing” configuration value is invalid" is there any workaround?

When i run it it gives error of sendingusing configuration value as invalid

When i want to sent message to email address on cell in sheet what will the code be , because .To = Range("D15") dont work and this is the range off the cell

it says Error: The process cannot access the file because it is being used by another process. help please

Error- The system cannot find the path specified'. This error is showing while the code can someone help me on this ?

Hi, can send a more mail in one click, from a Excel mailing LIST ?

Error : :The system cannot nind the files spicified" Please solution

i have error : Error The "Sendusing" configuration value is invalid i write it correct .Item(msconfigurl & "/sendusing") = 2

The transport failed to connect to the server, I am using gmail. Pleas help me

it's look's great Sir, I'm getting error when I run this code Error: The SMTP server name is required, and was not found in configuration source. I gave the same code what you gave, Can you help me on this pls

what is the msoconfigURL how did i get this for my email ID??

how to read emails from Gmail box using VBA?

Mr. Jenn, is it possible to run this script to send email from outlook account without an outlook app?

i am getting error for " SendUsing Configuration value is invalid" please suggest what should i do next

I get "Error: Access is denied" when trying to send by gmail. Any thoughts on what is going wrong?

Would this code work on visual studio?

Hi! Can you share how we can send it to a list of emails in excel?

how to add a loop to use excel list with multiple recepients and their relevant attachments?

I got the following error message. "Error: The requested body part was not found in this message" can you help please?

How is the highlighted font of ur code is red instead of blue...how did u do that

good morning is there a parameter to program the email for postponed sending?

Sadly doesn't work with excel 64-bit.

So now how do I make an Excel spreadsheet in my Gmail?

Does it stillwork

When my email id is wrong (i.e, not found in mail address book),the macro stops running. What can be done to prevent thia as this prevents from sending my others mails to users in the same column??