There are many libraries you can use to send emails from VFP applications. I created my own several years ago: a C# wrapper class using the .NET SMTPClient class, which I call using Rick Strahl's wwDotNetBridge. However, as discussed here, Microsoft no longer recommends using this class because it doesn't support modern protocols. As suggested in the article, I've rewritten my wrapper class to use the open source MailKit project.
Here's some code that shows how to use this wrapper class:
local loMail, ;
llReturn
loMail = newobject('SFMail', 'SFMail.prg')
with loMail
.cServer = 'MyMailServer.com'
.cUser = 'MyUserName'
.cPassword = 'MyPassword'
.nSMTPPort = 25
.cSenderEmail = .cUser
.cSenderName = 'My Name'
.cRecipients = 'someone@somewhere.com'
.cSubject = 'Test email'
.cBody = 'This is a test message. ' + ;
'<strong>This is bold text</strong>. ' + ;
'<font color="red">This is red text</font>'
.cAttachments = 'koko.jpg'
llReturn = .SendMail()
if llReturn
messagebox('Message sent')
else
messagebox('Message not sent: ' + .cErrorMessage)
endif llReturn
endwith
Here's what the received email looks like. Notice the attached image and the formatted text.
The class supports the following:
-
Text or HTML body
-
Attachments
-
Normal, CC, and BCC recipients
-
SMTP or MAPI
-
Adjustable timeout
-
Adjustable security settings
-
Diagnostic logging
Basic Authentication is simply providing a user name and password to connect to a mail server. More and more mail services are moving away from Basic Authentication and implementing Modern Authentication, also known as OAuth2. Modern Authentication uses a two-step process to connect to a mail server: first obtaining a token (a string) from a web server, then using that token to connect to the mail server.
SFMail supports Modern Authentication through the cOAuth* properties. Simply set them to the appropriate values and SFMail takes care of both steps for you.
Office365.md has instructions for configuring Office 365 and getting the values you need for Modern Authentication.
-
cAttachments: A comma-comma-separated list of attachments for the email.
-
cBCCRecipients: A comma- or semicolon-separated list of BCC recipients for the email.
-
cBody: The email body. Use HTML tags to format the body as HTML.
-
cCCRecipients: A comma- or semicolon-separated list of CC recipients for the email.
-
cErrorMessage: The text of any error.
-
cLogFile: The name and path of a log file (SMTP only). The log file contains the dialog between MailKit and the mail server so you can debug any problems. Set it to an empty string (the default) to not do logging.
-
cPassword: The password for the mail server (SMTP only).
-
cRecipients: A comma- or semicolon-separated list of recipients for the email.
-
cReplyTo: The Reply To address for the email (SMTP only).
-
cSenderEmail: The email address of the sender (SMTP only).
-
cSenderName: The name of the sender (SMTP only).
-
cServer: The mail server address (SMTP only).
-
cSubject: The email subject.
-
cUser: The user name for the mail server (SMTP only).
-
lUseHTML: .T. to send the email as HTML or .F. to use plain text. It defaults to .F. but is automatically set to .T. if you set cBody to a value containing both "<" and ">". You can set it back to .F. if desired before calling Send.
-
lUseMAPI: .T. to use MAPI or .F. (the default) to use SMTP. SFMail uses Craig Boyd's VFPExMAPI.fll if this property is .T.
-
nSecurityOptions: The SecureSocketOptions value to use; see the MailKit documentation for the values) (SMTP only). The default is 1 (Auto), which I find works best for most servers.
-
nSMTPPort: The SMTP port to use (SMTP only). The default is 25.
-
nTimeout: The email timeout in seconds (SMTP only). The default is 30.
-
cOAuthURL: The URL to obtain an OAuth 2.0 token.
-
cOAuthClientID: The OAuth2 Client ID.
-
cOAuthClientSecret: The OAuth2 Client Secret.
-
cOAuthScope: The OAuth2 scope. For Microsoft 365, use https://outlook.office.com/SMTP.Send.
To use SFMail, instantiate the SFMail class, set the appropriate properties, and call the SendMail method. See the sample program at the top of this document.
To deploy SFMail with your application, add SFMail.prg and wwDotNetBridge.prg to your project and include the following files with the files distributed with your application:
-
BouncyCastle.Crypto.dll
-
CLRHost.dll
-
MailKit.dll
-
MIMEKit.dll
-
SMTPLibrary2.dll
-
VFPExMAPI.fll (only needed if you use MAPI)
-
wwDotNetBridge.dll
Note: if your app runs from a network folder, you will likely need to distribute a config file that tells .NET to allow remote execution. Rename myapp.exe.config included in this repository to the name of your EXE; for example, for an EXE named Customers.exe, rename myapp.exe.config to Customers.exe.config and distribute it with the application.
The source for the .NET wrapper used by SFMail is in the SMTPLibrary2 folder; SMTPLibrary2.sln is the C# solution file. ("SMTPLibrary2" because the older wrapper I mentioned earlier was "SMTPLibrary".)
See How to contribute to SFMail for details on how to help with this project.
See the change log for release information.