DEMO Send Email Using CDO

[(X)]

Demo Send Email Using CDO 2.G32 (6.24 KB)

Are you trying to send e-mails from GB32 using CDO via smtp.gmail.com?

Things have changed a bit at Google...

You can still send emails from GB32 but now Google requires your app to provide a 16 chr passcode which they will provide for you after you enable 2-step authentication and manually request Google to generate the passcode.

Here is a small video clip:

    youtu.be/TUfvVWc6Oy4

[(X)]

Further explanation from BING:

The introduction of the app passcode is part of Google's effort to enhance security. When you enable 2-step authentication, it adds an extra layer of security to your account. After you've set it up, you'll sign in to your account in two steps using:

1. Something you know (your password)
2. Something you have (like your phone or a security key dongle)

Step 2 is where the app passcode comes into play. When you access Google services via less secure apps or devices, they can't prompt for the second verification step. So, instead, you generate an app passcode, which serves as a one-time-use password for the app or device.

In the context of sending emails from GB32 using CDO via smtp.gmail.com, the app passcode is used to authenticate the email sending process. This is because Google considers email clients like GB32 to be less secure, and the normal process of asking for a username and password isn't considered secure enough.

So, to continue using GB32 to send emails via Google's SMTP server, you need to generate this 16-character app passcode from your Google Account settings and use it in place of your regular password. This way, even if someone were to gain access to the app passcode, they wouldn't be able to access your Google Account because the app passcode doesn't work for web login. It's a way to allow less secure apps to access your Google Account in a more secure manner.

Remember, each app passcode is specific to the app and device you use it on, and you can always revoke it later if you stop using the app or lose your device. This is part of why app passcodes enhance the security of your Google Account.

[(X)]

Alternatives?

Certainly! When it comes to alternatives for **CDO (Collaboration Data Objects)**, especially for sending emails programmatically, there are several options you can explore:

1. **SMTP Libraries**:
- Instead of using CDO, you can directly interact with SMTP servers using various programming languages. Libraries like **`smtplib`** in Python or **`System.Net.Mail`** in C# allow you to send emails via SMTP without relying on CDO.
- These libraries provide more control and flexibility for sending emails, including authentication, attachments, and custom headers.

2. **Third-Party Email APIs**:
- Consider using third-party email services that offer APIs for sending emails. Popular options include:
- **SendGrid**: Provides a reliable email delivery service with a straightforward API.
- **Mailgun**: Offers email automation and tracking features.
- **Amazon SES (Simple Email Service)**: Part of Amazon Web Services (AWS) and provides scalable email sending capabilities.
- **Twilio SendGrid**: Another robust email delivery service with a user-friendly API.

3. **Apps Script for Gmail**:
- If you're working within Google Workspace (formerly G Suite), **Google Apps Script** allows you to automate tasks in Google Sheets, Docs, and Gmail.
- You can use it to send emails via Gmail, especially if you're dealing with Google Sheets data or other Google services.

4. **Custom SMTP Implementation**:
- Build your own custom SMTP client using low-level socket programming. While this approach requires more effort, it gives you complete control over the email sending process.
- You'll need to handle SMTP commands, establish connections, and manage message formatting.

5. **Alternative Libraries**:
- Explore other libraries specific to your programming language or framework. For example:
- **JavaMail API** for Java applications.
- **Nodemailer** for Node.js.
- **SwiftMailer** for PHP.

Remember to choose an alternative based on your specific requirements, such as ease of use, security, and scalability. Each option has its strengths and limitations, so pick the one that best fits your project! 🚀

Source: Conversation with Bing, 2024-02-15
(1) Sending Email using CDO, not wokring. Need alternative to CDO.. community.qlik.com/t5/QlikView-App-Dev/Sending-Email-using-CDO-not-wokring-Need-alternative-to-CDO/td-p/1537835.
(2) Top 10 CDO Technologies Alternatives & Competitors - G2. www.g2.com/products/cdo-technologies/competitors/alternatives.
(3) Any alternative to CDO.message for sending emails through gmail using .... stackoverflow.com/questions/62999011/any-alternative-to-cdo-message-for-sending-emails-through-gmail-using-vba.
(4) Alternative to CDO - MS Exchange - Spiceworks Community. community.spiceworks.com/topic/2220262-alternative-to-cdo.
(5) undefined. qlikpad.com/qlikview-scheduled-reports-sending-excel-via-email/.
(6) undefined. qlikpad.com/qlikview-scheduled-reports-sending-excel-via-email-part-2/.
(7) undefined. schemas.microsoft.com/cdo/configuration/.
(8) undefined. schemas.microsoft.com/cdo/configuration/sendusing.
(9) undefined. schemas.microsoft.com/cdo/configuration/smtpserver.
(10) undefined. schemas.microsoft.com/cdo/configuration/smtpauthenticate.
(11) undefined. schemas.microsoft.com/cdo/configuration/smtpserverport.
(12) undefined. schemas.microsoft.com/cdo/configuration/sendusername.
(13) undefined. schemas.microsoft.com/cdo/configuration/sendpassword.
(14) undefined. schemas.microsoft.com/cdo/configuration/smtpusessl.
(15) undefined. schemas.microsoft.com/cdo.

[Roger Cabo]

I used to send email by my own Webserver in PHP.

I logged in by a Windows http XML Funktion.. in the same way to call a website.. then crypt in gb32 email and text, submitted to a .php site, and the php code depuzzled the contents and email ans send.

Okay the ugly thing was to have a php Webserver..

For sure its much easier to have a direct process instead of an external service.

Could be possible that your own mail service can be blocked by other email and data servers because of security reasons. That does not happen if you use pho and the internal email client.

Anyway it's a difficult task to get the complete process permanently to work and run..