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?
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
No i am passing it false
That's the problem. If you want to send HTML formated mail, last parameter must be TRUE. If is FALSE, will be sent as plain text.