Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- send email to person A:
- project number #### is due in ## days (where 1<##<30), the details of this
- project can refer to file ####.
- Send email to admin:
- Please prepare the document for project #### and hand it to person A
- if(Quotation for approval)
- {extract data following the "Quotation for approval" format of the body of
- the email;
- Copy and paste data from email body to rows and column in SQL;
- }
- .
- .
- .
- .
- .
- Export SQL table into excel file then send to me and cc to company email;
- if(due date >30)
- {}
- if(due date <=30)
- {get project number;
- get project name;
- get due date;
- get person in charge email;
- days to go = due date - today();
- send email to person in charge (project "project number" "project name" is
- due in "days to go");
- send email to admin (project "project number" "project name" is due in "days
- to go" please prepare documents before "due date".);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement