I have report in which due date field is there, that due date field is calculated by a variable.
if the due date match with today date then a email should be send. i m using Nav2013R2.
And what is your question?
What I understand is you want to send an email if Due date is TODAY date in the System.
Did you tried anything?
Check this out for help
My question exactly is what RockWithNAV has said..
So RWN's reply answer your question? Or?
And he asked you a question, if you had tried anything to get there? Is the report already functional, have you email enabled it? So where are you in the process? Have you made a task to run in the job queue to automate it?
YES i have tried, using SMTP Mail codeunit but its not working.
What is not working? Do you get any errors or what happens?
My email part is working now, i want to show data in mail body in table format, for that i m using html but not working its show like this
<table border="1"><tr><th>Export Invoice No</th><th>Export Shipment No</th><th>Port of Loading</th><th>Port of Discharge</th></tr><tr><td>FEI-1819-013</td><td>PESHP/1819/014</td><td>NHAVA SHEVAINDIA</td><td>CAPE TOWN, SOUTH AFRICASOUTH AFRICA</td></tr></table>
How does you code look link? You are using codeunit 400 - "CreateMessage" and "AppendBody"?
Are you passing last parameter as TRUE??
yes i am using codeunit 400