Check to send mail NAV

(0) Share

Report

Posted on by Community Member

Hello world,

i want to create a CodeUnit to check 2 fields (Date) if they are empty, dont do anything, if not add 30Days and check if its >= the previous Field. after comparing send a mail message

Thanks for helping me

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

what is your question now?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thank you for responding.

my question is , how can i do that ??

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

Did you try anything? Please provide what did you try and what issues are you facing.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i created a Function (CheckToSendMail) and i put this :

LOCAL CheckSendToMail()

Employee.FINDFIRST;

REPEAT

IF

Employee."Echéance Passeport 1" <= CALCDATE('<TODAY+30D-1>')

THEN EXIT

ELSE

SMTPMail.Send ;

IF

Employee."Echéance Passeport 2" <= CALCDATE('<today+30D>')

THEN EXIT

ELSE

SMTPMail.Send;

UNTIL Employee.NEXT =0;

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

check this link about CALCDATE

msdn.microsoft.com/.../dd301368(v=nav.90).aspx

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi Zakariia Bou,

It is same as a request from my customers. If Date of Expiry of one of two passports is going to be expired within 30 days, send an email to HR Staff to notify them.

LOCAL CheckSendToMail()

IF (Employee.FINDFIRST) THEN

REPEAT

IF (Employee."Echéance Passeport 1" IN [TODAY..CALCDATE('<+30D>', TODAY)]) THEN

SMTPMail.Send

ELSE IF (Employee."Echéance Passeport 2" IN [TODAY..CALCDATE('<+30D>', TODAY)]) THEN

SMTPMail.Send;

UNTIL (Employee.NEXT = 0);

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

Always use FINDSET for REPEAT UNTIL

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you so much Khoa Nguyen

I appreciate that

Was this reply helpful? Yes No
4BzSoftware 6,073 on at

Like (0)

Report

You're welcome!

Have a nice day to all :-)

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (0)

Report

Hi

You can refer my blog, in the blog the code checks for the visa expiry date, if visa expires in a month then a email is send to the HR. you can code on similar lines

http://www.cloudfronts.com/run-batch-check-visa-expiry-date-employees-send-email-visa-expires-month-dynamics-nav/

Was this reply helpful? Yes No