syed_iqbal
01-19-2017, 01:00 AM
Hi,
pls go through code in the attached file. there are three criteria's in the code.
Criteria:
1) if employee status is "Resigned" ("Status" column mentioned in "Master" sheet) then mail should not go to that person.
2) if employee status is "Working" and there is no individual attachment for him, then mail should go with remaining all attachments (attachment file path's are mentioned in 'column F' in "Emp Information" Sheet).
3) if employee status is "Working" and there is individual attachment, then mail should go with remaining all attachments (attachment file path mentioned in each individual cell in 'Column F' in "Emp Information" sheet) including individual attachment (attachment file path mentioned in each individual cell in 'Column E' in "Emp Information" sheet).
Examples:
1)Employee's A1,A5,A9,A10,A15 are resigned. So they should not get email.
2) Employees's A3,A12 are Working and there is no file to attach for them (Column E in "Emp information" sheet). then Mail should go with remaining all attachments in column F in "Emp information" Sheet ("Covering letter.txt","1.txt")
3) for employees A2,A4,A6,A7,A8,A9,A11,A13,A14 , mail should go with all attachments (individual & remaining files)
I hope criteria's are clear.
i can't understand where the mistake was occurred in my code. Pls help me
Thank you in advance
regards
iqbal
pls go through code in the attached file. there are three criteria's in the code.
Criteria:
1) if employee status is "Resigned" ("Status" column mentioned in "Master" sheet) then mail should not go to that person.
2) if employee status is "Working" and there is no individual attachment for him, then mail should go with remaining all attachments (attachment file path's are mentioned in 'column F' in "Emp Information" Sheet).
3) if employee status is "Working" and there is individual attachment, then mail should go with remaining all attachments (attachment file path mentioned in each individual cell in 'Column F' in "Emp Information" sheet) including individual attachment (attachment file path mentioned in each individual cell in 'Column E' in "Emp Information" sheet).
Examples:
1)Employee's A1,A5,A9,A10,A15 are resigned. So they should not get email.
2) Employees's A3,A12 are Working and there is no file to attach for them (Column E in "Emp information" sheet). then Mail should go with remaining all attachments in column F in "Emp information" Sheet ("Covering letter.txt","1.txt")
3) for employees A2,A4,A6,A7,A8,A9,A11,A13,A14 , mail should go with all attachments (individual & remaining files)
I hope criteria's are clear.
i can't understand where the mistake was occurred in my code. Pls help me
Thank you in advance
regards
iqbal