How to send email using Gmail via Excel VBA

We can send email using Gmail, Hotmail or Yahoo directly from Excel using VBA.
View the complete code and more details: www.exceltraini...

[@bobarnold4435]

One of the best instructional videos I've seen. Well paced, multiple explanations of the same concept, and I particularly liked the way the instructor created problem and then worked through them. I feel watching multiple videos on the subject is not necessary. Tkx

[@amjadansaree]

Hello Mr Dinesh Sir, You are my Teacher like "eklavya Guriji" for All of your Tutorials Thank you very very very much for all of your tutorial, This is really work fine

[@cavokrider]

OMG! This is the Best video ever! Thank you!

[@eprzepiora]

Thank you very much; It took me 5 mins to copy your code and integrate this within my application, This is the best piece of code I have seen for a bit. You also explained it with such clarity, Greetings from London, UK Edward

[@awanasetia]

Hello Mr Dinesh, You are my Hero :D, Thank you very much for all of your tutorial, This is really works.

[@muhhd123]

Thank you Daniesh for the helpful video.

[@Exceltrainingvideos]

Glad it was helpful!

[@krn14242]

Thanks Dinesh. Strange it still worked. Check your authentication line. I think you wrote SMPT vs. SMTP. Thanks for the great tips on sending gmail via excel.

[@Exceltrainingvideos]

krn14242 Thanks! I placed a note next to SMPT as SMTP.

[@bhavyabansal11]

Works like a charm!! Thanks so much Dr. Takyar!

[@mikevanwieringen9883]

Thanks for this well explained tutorial.

[@Santoshnikam88]

Thank You Sir. It worked perfectly...

[@robertheskett7923]

Works great. Is there anyway to get a reference of cells to be the To and from, so if the addresses change you can a cell instead of modifying the script?

[@mdarshadbashir7803]

Thank You immensely for doing a Great Job in VBA Excel . Your expositions are really remarakble. Especially in the way you present them in a very thorough way. Thanks and Thanks a lot indeed.. Can you also please show how to read our Gmails messages using VBA Excel or make a back up of these messages in an excel worksheet

[@imrananwar2044]

Hi Sir,Love your Videos.Very Special Thanks to you.These help me a lot

[@tensketch385]

Hi Dinesh. I'm using an automated Excel Invoice, where i want to send email by clicking a button, and it send email through gmail to the client. When i click the send email button, Each time the Macro should capture email id from a cell in the excel invoice. I have already created a Macro for saving as PDF. PDF invoice should automatically be attached to the email. Subject will be the filename of the invoice. Anyway to do this?.

[@panchitomontero9051]

Very helpful. Thanks! I would very much be interested to implement something like this, but with multiple emails with an Excel file that contains columns with all sort of data. The emails are included in the Excel file, so it would be a row per recipient. Do you have a video for something like that?

[@Exceltrainingvideos]

This link will help: www.exceltrainingvideos.com/how-to-create-notifications-in-excel-with-vba-revisited/ Or search www.exceltrainingvideos.com

[@nitishvishwakarma3743]

Hi Dinesh Sir, Thanks for your valuable videos. Can you help me out for a problem I have written below- I want to automate Google spreadsheet add-on "Yet another mail merge" through Script Editor. Or tell me how to mail merge through Ms-Word but with personalized Subject Lines.

[@mukundjoshi598]

Hello Sir, thanks for the guidance, It's easy to understand and implement. I am stuck with one thing, so need your help if possible. I can't restrict my mail body content within certain cells, it might vary depending on the email. Hence earlier i used to send multiple emails using macro via Outlook in Excel itself, but now need to use gmail. In Outlook, mail body used to be my selection of cells in excel. I am unable to do it in Gmail. In short, Activesheet.selection needs to be my Email Body in Gmail. Kindly help. Thank you.

[@dl223678]

Hi Dinesh, I was wondering if there was a way to send the current file you are working on? Thanks!

[@Exceltrainingvideos]

Danny Lau Try this: www.exceltrainingvideos.com/how-to-use-automation-to-send-ms-outlook-mail-using-excel-vba/

[@RobGoldstein]

Thank you for posting this. It is half of what I am trying to do. Is it possible to do a mail merge using Gmail with this ?

[@Exceltrainingvideos]

I just replied to that question.

[@RobGoldstein]

@@Exceltrainingvideos do you have a link?

[@armin8558]

Thanks a lot, everything is working as id should. Is there a way to create a PDF file of an area without using pdf creater, just using vba?

[@Exceltrainingvideos]

+Armin Just define the range like Range("A8:E20") that you wish to convert to PDF in your VBA code.

[@patinom11ify]

Hello Dinesh. Thanks a lot for your video. I cant seem to run it perfectly. I dont recieved the mails nor the notification from gmail. However, I will also like to know how can I input in the mail body, information from an active excel sheet, and how can I set the sendto adress also from a cell on the excell sheet. thanks

[@Exceltrainingvideos]

+Mateo Patiño Have a look at this video: www.exceltrainingvideos.com/send-email-using-gmail-with-excel-vba/ Use the range or cells property to get information from your worksheet into the macro.

[@robertmccahon7]

Try setting your smtpserverport to 465

[@martinj9285]

Dear Sir,, Big fan of u..😇 ..I need to insert the PNG or JPG snap file into the GMAIL BODY of the Content. Like after "Hi Team,".......Can u plz tell me that how to insert into the gmail body?.. I am getting as a empty mail only..I am using send keys and object and Range HTML also..But no uses...!!!

[@tendentiousproductions9714]

This doesn't work for 2016 Office for the Mac Right?

[@NickHorton-q9w]

Is it possible to add a JPG to the bottom of the email you have created.

[@ianreeve3200]

I would like to display the email before sending. Please indicate how this can be done? I have looked at the reply below but can't find the answer in the link you gave. Thanks

[@Exceltrainingvideos]

This link will guide: www.exceltrainingvideos.com/send-numbered-message-automatically-through-outlook/

[@boggulasivakumar3057]

Hi Sir, First of all thanks for sharing your knowledge to all, I need to copy cell range form excel to paste in to gmail body pls help me to solve this. thanks in advance .

[@nguyenvinh2648]

Dear Mr Dinesh Kumar Takyar Best wish for you during this pandemic i want to ask you a question, because i already copy all your code, run it Ok but gmail did not send anything. I also turn off the security, so could you please show me what happen Thank you very much

[@Exceltrainingvideos]

Gmail keeps on changing its code. Therefore you must look for the latest VBA code to access the newer html elements.

[@NeerajNatu]

the mail is not going....I have no errors in VBA popping up, the msgbox says mail sent as i had typed in but still no mails in my gmail account.

[@krishnakishorepeddisetti4387]

hi Dinesh, thank you for your wonderful tutorial. the code was working fantastic.but, is there a way where i can set the bounce back mail to my email id when the mail is not delivered. if that can be incorporated. the code is just great. right now i am not getting bounce back mails. will be waiting your reply thanks and regards kishore

[@msg4sam546]

Hi Sir, whether we can send multiple bulk emails with different contain based on value in excel. I want to send through Gmail only.

[@Exceltrainingvideos]

These tutorials will help: www.exceltrainingvideos.com/send-emails-to-multiple-persons-with-multiple-attachments/ To use Gmail you can try: www.exceltrainingvideos.com/send-email-using-gmail-with-excel-vba/

[@magibis7519]

Really usefull sir

[@satree5]

Dear Sir, I am a teacher and have to send progress of my students to their parents on a weekly bases. I created a workbook where i plot their weekly progress and I would like to ask if you can make a video to explain the vba code that I found on the internet. I am a novice when it comes to VBA but would like to learn more. Please help.

[@tranejones1018]

hi, I would like to attach the last date modified file (automatically), how can I do that? thank in advance!!

[@septianitrifosa9141]

do u know how to run macro automatcally when data entered cell?

[@Exceltrainingvideos]

www.exceltrainingvideos.com/highlight-excel-cells-while-entering-data/

[@sachinshinde5997]

Hi Sir ...Excel cha code for sending mails via gmail along with attachment file.. please aap iska video banao...

[@tanmoyd]

Does it take some time to send/receive the email? I sent it and got the success message as well, but I do not see the email in my Gmail inbox.

[@Exceltrainingvideos]

This link with a downloadable sample file for practice will help: www.exceltrainingvideos.com/send-email-using-gmail-with-excel-vba/

[@MattLutey]

Dr. Takyar,Every day I want to send an email with an update given the current cell's value for the day. How can I modify the message body to do this?

[@Exceltrainingvideos]

Use a variable and assign the current cell's value into the variable. Finally use the variable for the body. You can also assign the current cell's value to the '.body' .

[@NirmalSingh53]

Sir I have tried this programme and it is working perfectly . I want to add this code with a n excel Invoice vba which goes like this "Sheet1.Range("A2:R27").ExportAsFixedFormat xlTypePDF, Filename:= _ "C:\Billing Data ew_sale_invoice" " so that my invoice should be converted into pdf as well as mailed via gmail. Would you help me please.

[@Exceltrainingvideos]

www.exceltrainingvideos.com/tag/how-to-save-invoice-template-as-pdf-file/ Or search www.exceltrainingvideos.com

[@SUR-NI-VARA]

Sir, Can I have the code to pick up, email address and attachment from Excel Table Active Row 👍 Thank you in advance.👍

[@Exceltrainingvideos]

Yes, sure

[@medrayan8418]

Dear Sir, I have a lisbox filled with data ( many lines and some columns ) and i wand to send all data in listox via email. would you please assist me to do that ? best regards

[@paulalbertweis3011]

Hello... This is great dialogue. Could someone recommend how to embed a longer Mail.TextBody where VBA can update certain verbiage as it loops though the multiple Mail.To's . The video has a simple one liner, but I want to have many more (up to 20) Mail.TextBody lines, include closing salutation. PLEASE HELP ME

[@saveriomartino9201]

Hi Mr. Dinesh, i'm italian so i apologize for my english, only a question: in my client (Outlook) there are 4 account, and the one that i would use from vba isn't the first one (thet the vba sub use by default) what can i do? otherwise i have to remove all my account and reinstall all again. Thank you very much. Saverio

[@sridharkrishnappanavanerth3388]

Sir, my file has some vba Macros, and about 5 work sheets, i only want a single file to be sent via gmail, what is the procedure sir,

[@Exceltrainingvideos]

You want to send one worksheet?

[@sridharkrishnappanavanerth3388]

@@Exceltrainingvideos yes sir, only one worksheet out of the macro enabled workbook containing say 5 or more worksheets. And also that worksheet format will be .xlsx. and the complete process should be automated.

[@ЭльмарИдрисов-г5э]

I have 2 questions: 1. How to display email before sending it ? It is important as I want to make adjustments and then click "send". 2. How to attach current open excel from which macro is written and which does not need to be saved after being emailed?

[@Exceltrainingvideos]

kzbin.info/aero/PLFoKoDG_7gtKiLkCe_k7RcOrX7E-4TIbe

[@ЭльмарИдрисов-г5э]

Not sure how this playlist is going to help me. I did not find needed information.

[@ianreeve3200]

I too need to display before send, did you manage to do it? If so how please

[@sayantanikayal1132]

sir, there is no error showing in my code .the msg box is showing that you mail has been sent but when i am opening the gmail account there i didnt forund any excel msg i had mail. please solve the prob n rply as soon as possible thank you sir

[@khanriza]

Can you add an authenticating password to this script so that you don't have to disable your security settings in your email account?

[@sasamilosevic2205]

Hello, I fallowed all your steps and it seem like its working but email just dont arrive to inbox, i tired with multiple accounts of gmail. What to do?

[@Exceltrainingvideos]

This link migh help: www.exceltrainingvideos.com/send-email-using-gmail-with-excel-vba/

[@sasamilosevic2205]

I tired everything, email just don t arrive :( Do You know what is the problem?

[@Evolutiontestweekies]

Can i use this concept with Mail becky application?

[@Exceltrainingvideos]

No idea.

[@Evolutiontestweekies]

@@Exceltrainingvideos Thank you

[@yopieaprizal2327]

should i activate outlook in my pc? bcs the code vwasn't working... there s no email sent in my gmail...

[@Exceltrainingvideos]

This link will help: www.exceltrainingvideos.com/send-email-using-gmail-with-excel-vba/ Get the book Excel 2016 Power Programming with VBA: amzn.to/2kDP35V If you are from India you can get this book here: amzn.to/2jzJGqU Or visit www.exceltrainingvideos.com to learn more for free.

[@ce-shpweb6313]

Morning: I got a error ; .AddAttachment "C:\Users\Ce-SHP\Desktop\email-via-gmail.txt", can you help me?

[@v6kuchi]

Hi Im trying to list the numbers of a sequence of intervals A1 will have (13456666-13456668) and I should get the below in A2 (13456666,13456667,13456668) I cant get going with this, any help with automating this is appreciated

[@Exceltrainingvideos]

This link will help: www.exceltrainingvideos.com/unstack-data-automatically/

[@palaksoni8341]

Hi , How to send email automatically by fetching the records from Excel sheet and sent them bday wishes . Right now you have given hard coded email id

[@Exceltrainingvideos]

This VBA tutorial in Excel will guide: www.exceltrainingvideos.com/using-dates-with-excel-vba-to-automate-email-reminders/

[@umamaheswari9526]

Getting Compile Error Argument not optional for .AddAttachment Kindly help to find the solution

[@Exceltrainingvideos]

Have a look at this link and the VBA code: www.exceltrainingvideos.com/send-email-using-gmail-with-excel-vba/

[@umamaheswari9526]

Now I am not getting the error.Got mail sent message and no mails received in my mail box. Could you help me on this.

[@SantoshKumar-fr5tm]

Hi Dinesh, Very good video thanks for it. But can you please help me resolving my issue. I did exactly same what you explained but it is showing me error "The transport failed to connect to the server". What wrong i am doing. pl check. Thanks in advance. Santosh

[@Ganesh749]

Santosh Kumar It might be an issue with your internet connection or incorrect login credentials...pls check

[@Lark56]

Will this work in Word 2016 for all clients email ?

[@Because011]

Hello did you find an answer to your question? I have same problem and I am looking for it.

[@septianitrifosa9141]

Hi sir. thx for the tutorial.. it works .. but I have some problem, I want to send excel sheet an cell as the body of email not as the attachment.. can u help me solve this problem and show me the code? I've tried some code but it only works for outlook... I need the code to send it with CDO message.. can u solve this? thx

[@antoniosantos421]

Hello> Did you find a solution for this one?

[@septianitrifosa9141]

Im not... How about u?

[@septianitrifosa9141]

sorry which one?

[@antoniosantos421]

Having an email sent automatically on CDO basis and with the the rows that meet a criteria in the body of the message - hopefully in HMTL format.

[@septianitrifosa9141]

no.. Im not

[@anisharma7889]

Nameste Sir, Can we schedule every mail in Gmail And can we paste image in email body Thanks in advance

[@Exceltrainingvideos]

Should be possible.

[@anisharma7889]

@@Exceltrainingvideos please suggest

[@anisharma7889]

@@Exceltrainingvideos please help

[@ulludacharkha]

Dear Takyar Ji, Jai Hind ! I am getting error message at " The "SendUsing" configration value is invalid How to resolve it ?

[@Exceltrainingvideos]

This link with a downloadable sample file will help: www.exceltrainingvideos.com/send-email-using-gmail-with-excel-vba/

[@gunindradas8042]

Sir how I can send multiple people and different attachment can it possible?

[@Exceltrainingvideos]

It's possible. You need to create the values: To: Body: Attachment: in your Excel worksheet and then loop through the data.

[@gunindradas8042]

Please sir upload a video in this topic

[@Exceltrainingvideos]

OK

[@gunindradas8042]

Thanks sir. It's very urgent. The video helpful for me.

[@JasonX888]

When I run the VBA, It only runs for a second and then stops

[@ThotaNagasudheer]

Thankyou Dinesh

[@Exceltrainingvideos]

Welcome! Please share this channel on Excel VBA with your friends too.

[@satishkumarn.2613]

Sir, Can we send mail by uninstalling outlook in system

[@Exceltrainingvideos]

Can I buy an orange in a shop without paying (money)?

[@karmegammariappan9115]

Hello Sir. I need your support on my below doubt. In my Company they using gmail application as front end for Sending/Receiving emails but backside it is running in our company server. I just trying to create a macro for sending automatic email with my company SMPT name and port number but i am not able to send mail using this and also advise should i give my password in code because my username already having access to connect with our server . Could you please support me on this.

[@Exceltrainingvideos]

Ask the system administrator.

[@raviroshan3904]

hi, i am just not able to send mail using this, i tried everything but its not working, the code runs and doesnt display any error but in email i dont see any send or received mail, when i remove "on error resume next" line from code then it gives error " the transport failed to connect to the server" plz help

[@Exceltrainingvideos]

Read the details carefully at this link: www.exceltrainingvideos.com/send-email-using-gmail-with-excel-vba/ Then watch the video.

[@Davidtresmoore]

I get "Compile error" when I try to run this, the problem starts with the line ending in "smtp.gmail.com", any suggestions?

[@Exceltrainingvideos]

Get the code from here: www.exceltrainingvideos.com/send-email-using-gmail-with-excel-vba/ Don't copy paste.

[@Davidtresmoore]

now I get the message "Run-time error '424': Object required" then when I click debug it highlights the line ending in smtp.gmail.com, how should I fix this?

[@gagansingh3481]

SIR I AM GETTING RUNTIME ERROR ON SUBJECT TELL ME THE SLOUTION PLEASE

[@Exceltrainingvideos]

Check your code.

[@apoorvajain7]

I exactly did the same but it's showing user defined type not defined help me out anyone

[@Exceltrainingvideos]

www.exceltrainingvideos.com/send-email-using-gmail-with-excel-vba/

[@niksarpate]

No error observed while running and no email sent. Please help

[@Exceltrainingvideos]

This video was first published in August 2014. The Google Mail website has changed. You need to inspect the HTML code and tweak the VBA code accordingly.

[@niksarpate]

@@Exceltrainingvideos .Ton thanks for this quick reply..Have a good day...

[@synergistixindia]

THANK YOU...

[@SaurabhSingh-qr8bu]

Dr. Takyar it is not working

[@ramkrishnarao1212]

Sir, one clarification

[@nitinsingh.2107]

Great

[@Exceltrainingvideos]

Glad to hear that. Please share with your friends.

[@nitinsingh.2107]

@@Exceltrainingvideos sure

[@infotech5520]

thx

[@hrm-e2c]

send a coding as a text file

[@depicon8042]

The smtp port should be 465

[@Exceltrainingvideos]

www.exceltrainingvideos.com/send-email-using-gmail-with-excel-vba/