Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. send email to person A:
  2. project number #### is due in ## days (where 1<##<30), the details of this
  3. project can refer to file ####.
  4.  
  5. Send email to admin:
  6. Please prepare the document for project #### and hand it to person A
  7.  
  8. if(Quotation for approval)
  9. {extract data following the "Quotation for approval" format of the body of
  10. the email;
  11. Copy and paste data from email body to rows and column in SQL;
  12. }
  13. .
  14. .
  15. .
  16. .
  17. .
  18.  
  19. Export SQL table into excel file then send to me and cc to company email;
  20.  
  21. if(due date >30)
  22. {}
  23.  
  24. if(due date <=30)
  25. {get project number;
  26. get project name;
  27. get due date;
  28. get person in charge email;
  29. days to go = due date - today();
  30. send email to person in charge (project "project number" "project name" is
  31. due in "days to go");
  32. send email to admin (project "project number" "project name" is due in "days
  33. to go" please prepare documents before "due date".);
  34. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement