Hi

I can save a workbook and get it sent to a certain person fairly straight forward, but say i have 2 users (USER 1 and USER 2) if user 1 saves the sheet send to user 2 and if user 2 saves the sheet send to user 1?

Reason i ask if this is possible, is because i am the creator of the sheet and i have built a task sheet that requires me to complete a task for 5 people, so if i go into the sheet and tick the tasks completed, it will email all 5, if they go into the sheet and request a new task then it will email just me......

Is there a way this can be done?

My code at the moment is.....

Please Login or Register  to view this content.
Also further on from this, if i go in and check a box so that the task is done, can it email the requested person to say "NAME has completed task TASK NAME", just by me checking the box?

Might as well ask the other query too.....

If i dont complete the tasks they have requested, (there are due dates on them) for example TASK 5 needs to be completed by 11/03/14, today is 12/3/14 so can it tell the requestee it was not completed on time? or can it send reminders to ALL users that TASK 5 needs completing on the 11/03/14?

That may all seem a bit far fetched, and too be honest i wanted to try and use Sharepoint Designer, but my IT dept are being a bit slow on allowing the Sharepoint foundation on our server.

Hope someone could at least point me in the right direction please?