I am wanting to use DBPro to send emails. I found an EXE, SendSMTP.exe, that will send the emails if you just pass it parameters. It then returns a code designating it's success in doing so. Right now this BATCH file works great:
del results.txt
@echo off
set errorlevel=
SendSMTP.exe /TO [email protected] /SUBJECT "Testing" /BODYFILE BODY.txt /FILES Scan.pdf /PASSX sd@ra$//rT==
echo %errorlevel% >> Results.txt
type Results.txt
pause
It captures the return code from the exe, writes it into Results.txt. There is only one problem, and that is the password (which I changed BTW) is stored in the batch file for all to see. Even if the batch file is deleted right afterwards, it is too much of a risk. I would much rather use
execute file in DBPro to pass the values directly to the EXE (
execute file "SendSMTP",arg$,"",1), but then I have no way of capturing that return code.
Any suggestions?