Then, we’re providing our login credentials.Thirdly, we’re setting the email content in our code.Firstly, we’re calling our Sub Procedure Send_Gmail_Macro.If Err.Description "" Then MsgBox Err.Description Set cConfig = CreateObject("CDO.Configuration") Firstly, as shown in method 1, bring up the Module window and type this code.ĬBody = "Hello.Finally, turn on Less secure app access.Thirdly, go to Security from your Google Account settings.Secondly, select “ Microsoft CDO for Windows 2000 Library” and press OK.Firstly, as shown in the first method, bring up the References dialog box.Additionally, we’ll need to enable Microsoft CDO from the References menu. Macro for Sending Email from Gmail Account in Excelįor this method, we need less secure app access from the Gmail account. Read More: Send Email from Excel VBA without Outlook (4 Suitable Examples)Ģ. Thus, we’ve shown you the first method of sending an email from excel using VBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |