Hi All, I have a spreadsheet that is updated throughout the day. Mainly new jobs with various details are added and sometime we even finish jobs and add a complete date.
Once this is done we then have to email various persons and advise that this particular job is done.
I would like to be able to automatically send an email to persons predetermined by simply adding the date to the complete cell. I would be just as happy to have a button or other trigger to send the email.
The function would take data from particular cells and email them thus saving me time in sending emails manually every time a job is finished.
I would be happy with a very simple email which simply drops in the information in a format that can be easily understood.
What would be even better is if it was linked to a customer MS Outlook form and the relevant data form the cells would be dropped into the form.
This way would look more professional than simply dropping in data to a blank email.

Any help or examples would be greatly appreciated.

many thanks Russ