VB6 - Send Email Using Hotmail, , Office 365
Có thể bạn quan tâm
The following vb example codes demonstrate how to send email using Hotmail, Outlook.com and Office 365 SMTP servers.
Hotmail, Outlook.com SMTP Server
Hotmail/Live/Outlook.com SMTP server address is smtp.office365.com. It requires explicit SSL (TLS) connection to do user authentication, and you should use your Hotmail/Live/Outlook.com email address as the user name for ESMTP authentication. For example: your email is [email protected], and then the user name should be [email protected].
| Server | Port | SSL/TLS |
| smtp.office365.com | 25, 587 | TLS |
Office 365 SMTP Server
Office 365 SMTP server uses 587 port and explicit SSL (TLS) connection.
| Server | Port | SSL/TLS |
| smtp.office365.com | 25, 587 (recommended) | TLS |
App Password and SmtpClientAuthenticationDisabled¶
If your account enabled two-factor authentication, you cannot login your account by normal user authentication, you should create an App Passwords and use this App Password instead of the user password.
You should also check if authenticated client SMTP submission (SMTP AUTH) is enabled:
Enable or disable authenticated client SMTP submission (SMTP AUTH) in Exchange Online.
Last update: Microsoft has disabled App password, you have to switch to Hotmail SMTP OAUTH and Office365 SMTP/EWS/Ms Graph API OAUTH. If you don’t want to change your code, you can have a try with EA Oauth Service.
Installation¶
EASendMail is a SMTP component which supports all operations of SMTP/ESMTP protocols (RFC 821, RFC 822, RFC 2554). Before you can use the following example codes, you should download the EASendMail Installer and install it on your machine at first.
Add reference in VB6¶
To use EASendMail SMTP ActiveX Object in your project, the first step is “Add reference of EASendMail to your project”. Please select menu -> Project -> References -> and select EASendMailObj ActiveX Object, click OK, the reference will be added to current project, and you can start to use it to send email in your VB6 project.
Add reference in VBA (EXCEL/Access/Outlook)¶
Open VBA IDE by press Alt+F11, Please select menu -> Tools -> References -> and select EASendMailObj ActiveX Object, click OK, the reference will be added to current VBA project, and you can start to use it to send email in your VBA project.
VB6 - Send email using Hotmail, Outlook.com, Office 365 - example¶
The following example codes demonstrate sending email using Hotmail, Outlook, Office365 SMTP server. In order to run it correctly, please change SMTP server, user, password, sender, recipient value to yours.
Note
To get full sample projects, please download and install EASendMail on your machine.
Const ConnectNormal = 0 Const ConnectSSLAuto = 1 Const ConnectSTARTTLS = 2 Const ConnectDirectSSL = 3 Const ConnectTryTLS = 4 Private Sub btnSendMail_Click() Dim oSmtp As New EASendMailObjLib.Mail oSmtp.LicenseCode = "TryIt" ' Set your Hotmail/Outlook/Office 365 email address oSmtp.FromAddr = "[email protected]" ' Add recipient email address oSmtp.AddRecipientEx "[email protected]", 0 ' Set email subject oSmtp.Subject = "test email from hotmail account" ' Set email body oSmtp.BodyText = "this is a test email sent from VB 6.0 project with hotmail" ' Hotmail/Outlook SMTP server address oSmtp.ServerAddr = "smtp.office365.com" ' For office 365 account, please change server address to: ' oSmtp.ServerAddr = "smtp.office365.com" ' User authentication should use your ' email address as the user name. oSmtp.UserName = "[email protected]" ' If you got authentication error, try to create an app password instead of your user password. ' https://support.microsoft.com/en-us/account-billing/using-app-passwords-with-apps-that-don-t-support-two-step-verification-5896ed9b-4263-e681-128a-a6f2979a7944 oSmtp.Password = "your password or app password" ' set 587 port oSmtp.ServerPort = 587 ' detect SSL/TLS connection automatically oSmtp.ConnectType = ConnectSSLAuto MsgBox "start to send email ..." If oSmtp.SendMail() = 0 Then MsgBox "email was sent successfully!" Else MsgBox "failed to send email with the following error:" & oSmtp.GetLastErrDescription() End If End SubHotmail SMTP OAUTH¶
If your account enabled two-factor authentication, you cannot login your account by normal user authentication, you should use SMTP OAUTH or App Password.
Microsoft Live SMTP servers (Hotmail, Oultook personal account) have been extended to support authorization via the industry-standard OAuth 2.0 protocol. Using OAUTH protocol, user can do authentication by Microsoft Web OAuth instead of inputting user and password directly in application. This way is more secure, but a little bit complex.
- Send email from Hotmail/Outlook/Live using user interaction OAuth
Or you can generate App Passwords and use this app password instead of your user password.
Office365 SMTP/EWS/Ms Graph API OAUTH¶
If your account enabled two-factor authentication, you cannot login your account by normal user authentication, you should use SMTP/EWS/Ms Graph API OAUTH or App Password.
Microsoft Office365 SMTP/EWS/Ms Graph API servers have been extended to support authorization via the industry-standard OAuth 2.0 protocol. Using OAUTH protocol, user can do authentication by Microsoft Web OAuth instead of inputting user and password directly in application. This way is more secure, but a little bit complex.
- Send email from Office365 using user interaction OAuth
- Send email from Office365 in background service
Or you can generate App Passwords and use this app password instead of your user password.
TLS 1.2 protocol¶
TLS is the successor of SSL, more and more SMTP servers require TLS 1.2 encryption now.
If your operating system is Windows XP/Vista/Windows 7/Windows 2003/2008/2008 R2/2012/2012 R2, you need to enable TLS 1.2 protocol in your operating system like this:
Enable TLS 1.2 on Windows XP/Vista/7/10/Windows 2008/2008 R2/2012
32bit/x64 ActiveX DLL¶
Seperate builds of run-time dll for 32 and x64 platform
| File | Platform |
| Installation Path\Lib\native\x86\EASendMailObj.dll | 32 bit |
| Installation Path\Lib\native\x64\EASendMailObj.dll | 64 bit |
Distribution¶
Standard EXE
For VB6, C++, Delphi or other standard exe application, you can distribute EASendMailObj.dll with your application to target machine without COM-registration and installer. To learn more detail, please have a look at Registration-free COM with Manifest File.
Script
For ASP, VBScript, VBA, MS SQL Stored Procedure, you need to install EASendMail on target machine by EASendMail installer, both 32bit/x64 DLL are installed and registered.
Từ khóa » Visual Basic Send Email Via Outlook
-
How To Send Emails From Outlook Using VBA Code? - WallStreetMojo
-
How To: Programmatically Send Email - Visual Studio (Windows)
-
VBA Send Emails From Excel Through Outlook
-
How To Send Emails In Using The Outlook Library
-
Send Outlook Emails With VBA Macros
-
Send Emails With Attachments From Excel Using VBA And Outlook
-
Send E-Mail In VBA Excel Through Microsoft Outlook (Video 1 Of 4)
-
Send An Email With Outlook Using VB .Net - Visual Basic .NET - Bytes
-
How To Write VBA Code To Send An Outlook Email
-
How To Send An Outlook Email Message Programmatically
-
Sending EMail Via Outlook - Access 2007 VBA
-
VB.Net - Send Email - Tutorialspoint
-
How To Send Email In Excel Using VBA? - Simplilearn