How does CmdEmail work?

Download CmdEmail

System Requirement

Installation

Uninstall CmdEmail

How to setup e-mail account settings.

sendmail -setup

The Settings dialog will appear.Please input the information given to you by your Internet Service Provider (ISP) or administrator.

Your Name: Friendly name of the addresser.
Your e-mail address: The addresser of the mail.
Outgoing SMTP server: Please refer to your ISP or network administrator.
Port of SMTP server: Default 25
Read receipt requested: For MS outlook only.
User Name: User name used to login the smtp server.
Password: Password used to identify the user.

Note: Unless your ISP have indicated that your service uses Secure Password Authentication, do not select the "my outgoing server requires authentication" check box.

Command Line Usage Guide

Integrate CmdEmail into your applications

If you are using VB/VC, you can use WinExec() or CreateProgress() function to run CmdEmail. If you are developing form, you can use HOST built-in to run CmdEmail.
(See example below)

How to send short message with one single command line.

Since CmdEmail version 2 , two new paramters is added to CmdEmail.

-subject
-body

You can specify the subject and body by the two parameter.

The following small program written in javascript show you how to create the command line:

Example : ( 1, single line 2 multi-line 3 html )

How to pass many parameters to CmdEmail.

Sample code of sending mail via oracle forms

This section explains how to send mail from oracle forms through CmdEmail. Sure, the form should be running on Windows box.

--How to create message file. Please use TEXT_IO to create the message file.
--How to call CmdEmail. Please use HOST procedure to run CmdEmail.

We have created an example demonstrate how to use HOST procedure to run CmdEmail. Please download the form from http://www.lv2000.com/examples/testmail.fmb

Sample code:

DECLARE
v_file_path varchar2(300);
v_sendmail_exe_path varchar2(300);
text_file text_io.file_type;
BEGIN
v_sendmail_exe_path:='D:\cmdemail\sendmail.exe' ;--TODO: Change the path
v_file_path := 'd:\emailmsg.txt' ;--TODO:

if :mailto is null then
message('Please enter the e-mail address of the recipients');
raise form_trigger_failure;
end if;

text_file:=text_io.fopen(v_file_path,'w');
-- write header
text_io.put_line(text_file,'to:'||:mailto);
text_io.put_line(text_file,'cc:'||:copyto);
text_io.put_line(text_file,'attachment:c:\temp_file1.txt');
text_io.put_line(text_file,'attachment:c:\temp_file2.doc');
text_io.put_line(text_file,'subject:'||:subject);
text_io.put_line(text_file,'delete_the_file:yes');--delete the message file when the mail is sent successfully.
text_io.put_line(text_file,''); -- delimiter between header and body
-- write body
text_io.put_line(text_file,:mailbody);
text_io.fclose(text_file);
host(v_sendmail_exe_path||' -m:'||v_file_path,NO_SCREEN);
END ;

Integrate CmdEmail into program written in VC (1):

SECURITY_ATTRIBUTES g_sa = {sizeof(SECURITY_ATTRIBUTES),NULL,TRUE};

CString strTempPath;
GetTempPath( MAX_PATH, strTempPath.GetBuffer(MAX_PATH) );
strTempPath.ReleaseBuffer();
CString strTempName;
GetTempFileName( strTempPath, "m", 0, strTempName.GetBuffer(MAX_PATH) );
strTempName.ReleaseBuffer();
HANDLE hFile = CreateFile( strTempName, GENERIC_WRITE,
FILE_SHARE_READ|FILE_SHARE_WRITE, &g_sa,
CREATE_ALWAYS, FILE_ATTRIBUTE_TEMPORARY, NULL );
if ( hFile != INVALID_HANDLE_VALUE )
{
DWORD dwLen=0;
CString sContent=_T("subject:this mail is sent by CmdEmail\r\n");
sContent += _T("\r\n");
sContent += _T("Dear Sir,\r\n");
sContent += _T("Hello world!\r\n");
WriteFile(hFile,sContent.GetBuffer(sContent.GetLength()),
sContent.GetLength(),&dwLen,NULL);
FlushFileBuffers(hFile);
CloseHandle(hFile);

CString sCommand=_T("D:\\working\\sendmail20\\Release\\sendmail.exe");
sCommand += _T(" -to:tiger@scott.com");
sCommand += _T(" \"-m:")+strTempName+_T("\"");

CString strTempNameOutput;
GetTempFileName( strTempPath, "m", 0, strTempNameOutput.GetBuffer(MAX_PATH) );
strTempNameOutput.ReleaseBuffer();
HANDLE hFileOutput = CreateFile( strTempNameOutput, GENERIC_READ|GENERIC_WRITE,
FILE_SHARE_READ|FILE_SHARE_WRITE, &g_sa,
CREATE_ALWAYS, FILE_ATTRIBUTE_TEMPORARY|FILE_FLAG_DELETE_ON_CLOSE, NULL );

if(hFileOutput!= INVALID_HANDLE_VALUE ){

PROCESS_INFORMATION pi;
STARTUPINFO si = {0};
si.cb = sizeof(si);
si.dwFlags = STARTF_USESHOWWINDOW | STARTF_USESTDHANDLES;
si.wShowWindow = SW_HIDE;
si.hStdOutput = hFileOutput;
si.hStdError = hFileOutput;
BOOL bOk = CreateProcess( NULL, sCommand.GetBuffer(1),
NULL, NULL, TRUE,
0, NULL,
NULL, &si, &pi );
if ( bOk )
{
CloseHandle( pi.hThread );
if (WaitForSingleObject(pi.hProcess,INFINITE ) == WAIT_OBJECT_0 ){
// flush the temp file's buffers....
BOOL bSucceed = FlushFileBuffers( hFileOutput );
// go to start of file....
DWORD dwPos = SetFilePointer( hFileOutput, 0, NULL, FILE_BEGIN );
char Buf[MAX_PATH];
ReadFile(hFileOutput,Buf,MAX_PATH-1,&dwLen,NULL);
if(dwLen>0){
if(dwLen<MAX_PATH)
*(Buf+dwLen)='\0';
MessageBox(Buf);
}else //sent successfully
MessageBox("sent");
}else{
MessageBox("failed");
}
CloseHandle( pi.hProcess );

}
CloseHandle(hFileOutput);
}
DeleteFile(strTempName);
}

Integrate CmdEmail into program written in VC (2):

SECURITY_ATTRIBUTES g_sa = {sizeof(SECURITY_ATTRIBUTES),NULL,TRUE};

CString strTempPath;
GetTempPath( MAX_PATH, strTempPath.GetBuffer(MAX_PATH) );
strTempPath.ReleaseBuffer();
CString strTempName;
GetTempFileName( strTempPath, "m", 0, strTempName.GetBuffer(MAX_PATH) );
strTempName.ReleaseBuffer();
HANDLE hFile = CreateFile( strTempName, GENERIC_WRITE,
FILE_SHARE_READ|FILE_SHARE_WRITE, &g_sa,
CREATE_ALWAYS, 0, NULL );
if ( hFile != INVALID_HANDLE_VALUE )
{
DWORD dwLen=0;
CString sContent=_T("subject:this mail is sent by CmdEmail\r\n\r\n");
sContent += _T("Dear Sir,\r\n");
sContent += _T("Hello world!\r\n");
WriteFile(hFile,sContent.GetBuffer(sContent.GetLength()),sContent.GetLength() ,&dwLen,NULL);
FlushFileBuffers(hFile);
CloseHandle(hFile);

CString sCommand=_T("D:\\working\\sendmail20\\Release\\sendmail.exe");
sCommand += _T(" -to:tiger@scott.com");
sCommand += _T(" \"-m:")+strTempName+_T("\"");

if(WinExec(sCommand, SW_HIDE)>31)
MessageBox("sent");
}