• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VB form Script needed

H

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
 
Hi Hayden ,


Are you saying that all you need is a procedure to send an email ?


What should this email contain , and who are the recipients ? Are they fixed , or will they change depending on any user input on the form ?


Narayan
 
Yes i would like a procedure/Script to send mails

I currently have a script that i use but i dont know how to change it to have a mail sent to different person every time - based on who logs in to the form , the mail is sent to a different person when submitted


Are you saying that all you need is a procedure to send an email ? (YES)


What should this email contain ,

( ALL THE ASPECTS OF THE FORM WHEN SUBMITTED


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)

)


and who are the recipients ?

(BASED ON THE PERSON THAT IS SIGNING IN AND SUBMITTING THE FORM THE RECIPIENTS WOULD CHANGE)


Are they fixed

(NO IT WOULD CHANGE EVERY MONTH)


, or will they change depending on any user input on the form ? YES
 
Hi ,


Since the code for sending the email is intimately tied up with the form's data , it would be nice if you could develop the form and the workbook as fully as possible , and upload it so that whoever helps you out with the email script will find it easier.


Narayan
 
https://docs.google.com/open?id=0B_8gsqDH91vgNEY0Y1FxaVZTajI4aU9RYk13S0dtZw


I have uploaded a excel file to google - the vb forms need to be run to be viewed
 
Hi Hayden ,


I find there are 3 user forms ; none of them has any code developed for their use. Are you going to develop this code ?


Narayan
 
Hi Hayden ,


Which means you need the code for the three userforms , and the email script ; this is quite a job ! I am not sure whether any one can give so much of time to develop this. Are you willing to wait for at least a week , or more ?


Narayan
 
A is the lowest person - the person who is raising the task

B is a supervisor

C is a Manger or the supervisors boss


basically there should be 2 checks before the task is approved
 
You must log in or register to reply here.
Back
Top