Hello,
I have this code :
The resulting message is :
I have this code :
B4X:
cSqlCegid = $"SELECT * FROM [dbo].[Z_IAUDITOR] where DATE_AUDIT <= CONVERT( date, DATEADD(day, ${nDays}, GETDATE()))
and DATE_AUDIT >= CONVERT( date, GETDATE())
"$
Dim cMsg as String
cMSg = $"
Date run : ${DateTime.Date(DateTime.Now)}
Sql Query :
${cSqlCegid}
"$
smtp.Initialize(SMTP_server, SMPT_Port, SMTP_Username, SMTP_Password, "SMTP_Audits")
smtp.HtmlBody = False
smtp.Body = cMSg
...
smtp.sendThe resulting message is :