Mail Private CurrentEmailIsFinished As Boolean Private HasErrorWithEmail As Boolean Private ErrorDescription As String Private Sub InitVariables () CurrentEmailIsFinished = True HasErrorWithEmail = False ErrorDescription = "" End Sub Private Sub oSmtp_OnAuthenticated () Application.
#Enable vba in excel 2016 install#
' To use the following codes, please download and install ' on your machine Option Explicit Private WithEvents oSmtp As EASendMailObjLib.
Gmail, Hotmail, Outlook.COM, Office365 and Yahoo SMTP Server Settings.Where can I get my SMTP email server address, user and password?.Send email from MS Excel using VBA and SMTP protocol.Send Email from Excel using VBA and VBScript - Tutorial.