Symptom
It was working properly and I can use my gmail from in my outlook. But it failed now.
Resolution
1. Logging into the address you want to use for sending email from Excel.
2. Visit the page https://myaccount.google.com/lesssecureapp
3. Click Enable Less Secure Apps.
- Click Done.
Conclusion
This happen because Google found suspicious activity and turn this OFF, you just need to turn in ON when facing problem with Google Mail in outlook or others program.
Google Mail Setting info
| Incoming Mail (IMAP) Server | imap.gmail.com Requires SSL: Yes Port: 993 |
| Outgoing Mail (SMTP) Server | smtp.gmail.com Requires SSL: Yes Requires TLS: Yes (if available) Requires Authentication: Yes Port for SSL: 465 Port for TLS/STARTTLS: 587 |