1 Attachment(s)
sending e mails from excel via outlook at diferent stages depending on cell data
Hi
I have attached a trial wb.
I have a code that will send an email depending on a date in column f.
It sends it to the email in the code.
What i am trying to acheive is that when column f date is today it will send an email to the persons email responsible in the row or from a list.if the operator enters a yes in column g no more emails until the date in column h is reached to continue all year. But if the cell in column g remains blank another overdue email would be sent until yes is enterd.
Each row could have a different email
And there would be at least 7 sheets for diferent sites
Is this possible ???
Any help would be appreciated
Peter
