How Do I Set Up Yahoo Mail SMTP Configuration

 

Introduction
Setting up Yahoo Mail SMTP configuration in Oracle APEX allows your applications to send emails through Yahoo’s email servers, enabling reliable communication such as notifications and alerts. Proper configuration is essential to meet Yahoo’s security requirements and ensure that emails are delivered successfully without being marked as spam or rejected.

Here is a detailed step-by-step guide to set up Yahoo Mail SMTP configuration in Oracle APEX:

1. Prepare Your Yahoo Mail Account

   • Make sure your Yahoo Mail account is active and can send emails via SMTP.

   • For enhanced security, generate an App Password if your account has two-step verification enabled. This password will be used instead of your regular Yahoo password.

2. Collect Yahoo SMTP Server Information
   Use the following SMTP server parameters for Yahoo Mail:

   • SMTP Server: smtp.mail.yahoo.com

   • Port: 465 (for SSL) or 587 (for TLS/STARTTLS)

   • Requires Authentication: Yes

   • Security: SSL or TLS depending on the port

3. Access Oracle APEX Email Configuration
   Log into Oracle APEX with administrative rights. Navigate to Manage Instance > Instance Settings > Email or the equivalent workspace settings page for SMTP configuration.

4. Enter SMTP Server Details

   • Set the SMTP Host Address to smtp.mail.yahoo.com

   • Set the SMTP Port to 465 for SSL or 587 for TLS

   • Enter your full Yahoo email address as the SMTP Username (e.g., yourname@yahoo.com)

   • Enter the SMTP Password, which should be your Yahoo account password or App Password if two-step verification is enabled

   • Enable SSL or TLS as required by the chosen port

5. Set the Default Sender Email Address
   Specify your Yahoo email address as the “From” or default sender address to avoid email rejection or spam filtering.

6. Save and Apply the Configuration
   Save the SMTP settings so Oracle APEX uses these parameters for sending emails.

7. Test Email Sending
   Use the APEX_MAIL package or a test page to send a test email and confirm that it is delivered:

   BEGIN
     APEX_MAIL.SEND(
       p_to   => 'recipient@example.com',
       p_from => 'yourname@yahoo.com',
       p_subj => 'Yahoo SMTP Test Email',
       p_body => 'This is a test email sent from Oracle APEX using Yahoo SMTP.'
     );
     APEX_MAIL.PUSH_QUEUE;
   END;
   

   Check the recipient’s inbox to verify successful delivery.

8. Troubleshooting Tips

   • Ensure the App Password is used if two-step verification is enabled.

   • Verify that outbound SMTP traffic on the selected ports is not blocked by your network.

   • Review Oracle APEX mail logs (APEX_MAIL_LOG) for errors or delivery issues.

   • Confirm that your Yahoo account is in good standing and not restricted.

9. Security Best Practices

   • Use App Passwords rather than your main account password when two-step verification is active.

   • Avoid storing SMTP credentials in plain text or unsecured locations.

   • Regularly monitor account activity and update passwords as needed.

By following these steps, you will enable Oracle APEX applications to send emails securely and efficiently through Yahoo Mail’s SMTP servers, ensuring your users receive timely and trusted communications.

Yahoo Mail also requires authentication for SMTP connections.

• SMTP Server: smtp.mail.yahoo.com

• Port: 465 (SSL) or 587 (TLS)

• Encryption: SSL or TLS

• Authentication: Required

• Username: Full Yahoo email address (e.g., your_email@yahoo.com)

• Password: Application-specific password (if two-factor authentication is enabled)

 

To configure Yahoo Mail SMTP in Oracle APEX:

BEGIN

    APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_HOST_ADDRESS', 'smtp.mail.yahoo.com');

    APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_USERNAME', 'your_email@yahoo.com');

    APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_PASSWORD', 'your_app_password');

    APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_HOST_PORT', '465');

    APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_TLS_MODE', 'SSL');

    COMMIT;

END;

/

Conclusion
By correctly configuring Yahoo Mail SMTP settings in Oracle APEX, you can leverage Yahoo’s email infrastructure for secure and efficient email delivery. Following best practices for authentication and encryption will help maintain the integrity of your messages and improve deliverability, ensuring your users receive important communications promptly.