SMPT mail activity: No such host is known

Also, you can check Send SMTP Mail Message, Message: 534: 5.7.9 Application-specific password required - #2 by marian.platonov

Try with:

Server = "smtp.gmail.com"  
Port = 587
Email = "your_username@gmail.com"
Password = "your_generated_app_password"