hayden_pinto
New Member
Hi
I am making a User form in Excel VB where
3 parties are involved
Person A ,B & C
Person A will log into the form and certain tasks are assigned to him when the task is compledted then he submits the form - (when the form is submitted an email is sent to Person B ) Person B will review the task and submit it in the same form (when the form is submitted an email is sent to Person C) who will approve the task or reject it -
what i require is the scrip for sending the mail to person B when A is submitting and scrip for sending the mail to person C when B is submitting.
The contents of the (Person A) form should be
User name - (First line)
Blank Text Box for free text - (2n line)
Drop down - (3rd line)
The contents of the (Person B) form should be
User name Person A - (First line)
User name - (2n line)
Blank Text Box for free text - (3rd line)
Drop down - (4th Line)
The contents of the (Person C) form should be
User name Person A - (First line)
User name Person B - (2n line)
User name - (3rd line)
Blank Text Box for free text -(4th Line)
Drop down - (5th Line)
Please help im going mad with these scripts
I am making a User form in Excel VB where
3 parties are involved
Person A ,B & C
Person A will log into the form and certain tasks are assigned to him when the task is compledted then he submits the form - (when the form is submitted an email is sent to Person B ) Person B will review the task and submit it in the same form (when the form is submitted an email is sent to Person C) who will approve the task or reject it -
what i require is the scrip for sending the mail to person B when A is submitting and scrip for sending the mail to person C when B is submitting.
The contents of the (Person A) form should be
User name - (First line)
Blank Text Box for free text - (2n line)
Drop down - (3rd line)
The contents of the (Person B) form should be
User name Person A - (First line)
User name - (2n line)
Blank Text Box for free text - (3rd line)
Drop down - (4th Line)
The contents of the (Person C) form should be
User name Person A - (First line)
User name Person B - (2n line)
User name - (3rd line)
Blank Text Box for free text -(4th Line)
Drop down - (5th Line)
Please help im going mad with these scripts