Hi,
Hope someone can help, I have tried, and got almost close from reading through the forms, i managed to find a macro that kind of worked for me, but then it just wouldnt send the email automatically when the criteria was met, ive lost the macro now so cant show you what i did have sorry
basically i want to be able to automatically email (without any user interface required if this is possible) every friday at say 1800, if its possible to determine a time, if i can email the value shown in a cell or maybe 2 different cells in a worksheet
so for example the email would say something like.
John has 20 Job remaining this month and Has completed 40 jobs this month
The values will be taken from the 2 cells in the worksheet, is this possible does anyone know
I only want it to send the email once per friday, not more than once
Thanks in advanced if anyone has a solution for this it would be much appreciated
Hope someone can help, I have tried, and got almost close from reading through the forms, i managed to find a macro that kind of worked for me, but then it just wouldnt send the email automatically when the criteria was met, ive lost the macro now so cant show you what i did have sorry
basically i want to be able to automatically email (without any user interface required if this is possible) every friday at say 1800, if its possible to determine a time, if i can email the value shown in a cell or maybe 2 different cells in a worksheet
so for example the email would say something like.
John has 20 Job remaining this month and Has completed 40 jobs this month
The values will be taken from the 2 cells in the worksheet, is this possible does anyone know
I only want it to send the email once per friday, not more than once
Thanks in advanced if anyone has a solution for this it would be much appreciated
