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

[@jiejenn]

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

[@TMKJFun]

Thanks for making this video. It is very helpful and very clear

[@jasonfleishman9884]

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

[@kotermack]

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

[@corporateactionazimut4132]

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.

[@ankitshsharma]

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

[@ingridglorieux6414]

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?

[@jiejenn]

Unfortunately I don't know the best way to use OAuth2 protocol in VBA, but if you have some experience with Python, OAuth2 is definitely the way to go to send email with Gmail.

[@fabioandresurbinasoares9046]

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?

[@jiejenn]

500 is a small number I won't worry about it, but I would suggest you separate them into batches between intervals.

[@tandy1972]

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

[@jiejenn]

I haven't try inserting an image to the email body. Will probably experiment a bit first.

[@matthieuboucher143]

@@jiejenn Hi Jie, I am looking to attach both an image in the body (saved from a printing area in a worksheet) and a PDF as an attachment. I would love to pick your brain on this one :)

[@sergioroselli5726]

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

[@haribhaskar72]

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

[@amardeepsinghrawat4986]

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

[@tandy1972]

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

[@flowdj00]

Would this code work on visual studio?

[@ClaudiaGillmanAcuña]

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

[@yashparekh22]

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.

[@jiejenn]

I will look into it.

[@yashparekh22]

Thank you... It would be very helpful if that is possible.

[@arshadali6842]

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

[@irinkhan8114]

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

[@williehanekom858]

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

[@jiejenn]

Not enough information to help. Maybe change to =Range("D15").value.

[@pauwelsgnanih7136]

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

[@kleber_bispo]

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

[@jiejenn]

If you know any programming, you can use Microsoft Graph API to to manage your Outlook tasks. learn.microsoft.com/en-us/graph/api/resources/mail-api-overview?view=graph-rest-1.0

[@yrlandrevancedelosa3690]

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

[@jiejenn]

You can create a list and iterate each email address.

[@manvimanglik8921]

thanks it really helped a lot

[@FrancescoSantoro80]

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

[@jiejenn]

You can look into Application.Wait function.

[@FrancescoSantoro80]

@@jiejenn good morning you could give me some more information that I'm not very practical thanks

[@AmitHattiholi]

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

[@KeffelewAssefa]

Thank you

[@hhexeh]

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

[@jiejenn]

You can make the subroutine serves as a function. To add multiple attachments, I'm going to have do some research.

[@dannyworshop1466]

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

[@jiejenn]

What value are you providing to the SendinfUsing property?

[@dannyworshop1466]

@@jiejenn all is good i found out there are lapses on the spelling, all is good. More power!!!

[@kajalkhatri9238]

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

[@AnthonyJohnFajardo]

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

[@LifewithFoods]

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

[@jiejenn]

Under Tools, go to Editor Format tab, from there, you can format the text.

[@LifewithFoods]

@@jiejenn thanks🙂

[@naveenkumarraju4129]

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

[@jiejenn]

Please refer your question on Stack Overflow.

[@saumyabhattacharya2067]

how to read emails from Gmail box using VBA?

[@anasqureshi113]

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

[@RishiLabs]

Does it stillwork

[@jiejenn]

It should.

[@mohamadtayb7711]

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

[@jiejenn]

Probably a typo somewhere in your script.

[@monitsharma6618]

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

[@mittapalli1990]

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

[@jenniferabraham4551]

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

[@lorenzokoerts4028]

Gmail no longer supports unsafe sources and therefore blocks SMTP requests from excel

[@StevenSchiff-rg5ic]

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

[@jiejenn]

Your request body is missing a thing or two, that's my guess.

[@StevenSchiff-rg5ic]

@@jiejenn thnak you for your reply... I entered exactly what your chatgpt instructions produced and I dont see anything missing...could the same question get 2 results for each of us?

[@jiejenn]

@@StevenSchiff-rg5ic hard to tell without looking at your script.

[@NothingMuchhere2see]

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

[@jiejenn]

Makes sure you provide the correct credential info.

[@opfmnegros-occfses5435]

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

[@pacoramirez7363]

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

[@jiejenn]

Not sure if I understand your question.

[@keesvandorsten5975]

Sadly doesn't work with excel 64-bit.

[@jiejenn]

I did the video using Office 64bit, so Excel 64bit should work.

[@irinkhan8114]

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