(Excel) Yahoo Mail - SMTP, IMAP, POP Authentication with App Password

See more Yahoo Mail Examples

An application can read and send email from Yahoo mail accounts, but now it must use an "application password" rather then the account owner's password.

Let's say your application is "Xyz". Each Yahoo Mail account owner would first need to go to the "Account Security" tab in her Yahoo Mail account settings and create an App Password. It is the App Password that is used with SMTP, IMAP, and POP instead of the normal account password. The Yahoo Mail account owner can choose to create individual app passwords, one for each app, or can create a single app password that she might use for all apps. Ultimately, this is just a way to allow the user to associate passwords with individual apps such that a password for an individual app can be changed or revoked without affecting other apps. This is also better security. It's the same idea as using a password manager. Rather than using the same password for all online accounts, each individual account has a generated password that is managed by a password manager service or program with a single master password.

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' To authenticate with Yahoo Mail in SMTP, IMAP, or POP, the full email address is the username, and a generated app password is the password.
' See Yahoo Mail Generate and manage third-party app passwords

' The information at the above linked web page is:
' Some older, third-party email apps (that do not use our Yahoo branded sign-in page) require you to enter a single password for login credentials. 
' To access your Yahoo Mail account on these apps, you'll need to generate and use an app password. 
' An app password is a long, randomly generated code that gives a non-Yahoo app permission to access your Yahoo account. 
' Youll only need to provide this code once to sign in to your third-party email app.
' 
' Generate an app password
' 
'     Sign in to your Yahoo Account Security page.
'     Click Generate app password or Generate and manage app passwords.
'     Enter your app's name in the text field.
'     Click Generate password.
'     Follow the instructions below the app password.
'     Click Done.
' 
' Use this app password and your email address to sign in to your email app.

' ------
' NOTE: The comment "Youll only need to provide this code once to sign in to your third-party email app." is assuming your app
' is persisting the user's password such that it re-uses it to authenticate each time it connects to the mail server.
' All SMTP, IMAP, or POP sessions must authenticate with each new connection/session.
' ------

' First, let's demonstrate IMAP...
Dim imap As Chilkat.Imap
Set imap = Chilkat.NewImap
imap.Port = 993
imap.Ssl = True

success = imap.Connect("imap.mail.yahoo.com")
If (success = False) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If


myYahooEmailAddress = "joe@yahoo.com"

myGeneratedAppPassword = "lrabkaprvntxdjmc"

' Sign into the app/service using your normal username
' Instead of your normal password, enter the app password above
success = imap.Login(myYahooEmailAddress,myGeneratedAppPassword)
If (success = False) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

success = imap.SelectMailbox("Inbox")
If (success = False) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

Debug.Print "Yahoo IMAP all good!"
Dim success As Boolean
success = imap.Disconnect()

' --------------------------------------------
' Now do Yahoo SMTP:

Dim mailman As Chilkat.MailMan
Set mailman = Chilkat.NewMailMan

mailman.SmtpHost = "smtp.mail.yahoo.com"

mailman.SmtpUsername = myYahooEmailAddress
mailman.SmtpPassword = myGeneratedAppPassword

mailman.SmtpSsl = True
mailman.SmtpPort = 465

Dim email As Chilkat.Email
Set email = Chilkat.NewEmail
email.Subject = "This is a test"
email.Body = "This is a test"
email.FromName = "Joe"
email.FromAddress = myYahooEmailAddress
' Please change the recipient before running this code..
success = email.AddTo("Chilkat","info@chilkatsoft.com")

success = mailman.SendEmail(email)
If (success <> True) Then
    Debug.Print mailman.LastErrorText
    Exit Sub
End If

success = mailman.CloseSmtpConnection()
If (success <> True) Then
    Debug.Print "Connection to SMTP server not closed cleanly."
End If

Debug.Print "Yahoo Mail Sent!"

' ------------------------------------
' Now do Yahoo POP3

mailman.MailHost = "pop.mail.yahoo.com"

mailman.PopUsername = myYahooEmailAddress
mailman.PopPassword = myGeneratedAppPassword

mailman.MailPort = 995
mailman.PopSsl = True

success = mailman.Pop3Connect()
If (success <> True) Then
    Debug.Print mailman.LastErrorText
    Exit Sub
End If

success = mailman.Pop3Authenticate()
If (success <> True) Then
    Debug.Print mailman.LastErrorText
    Exit Sub
End If

Debug.Print "Connected and authenticated with Yahoo POP Mail Server."