Background: I have a sheet that people enter their time worked into each
week. There is a column that shows the amount of working time that they
have yet to book. Each week I have to send an e-mail to all the people
on the sheet that have 0 hours left to book.
Please see attached example J
I would like to automate this.
I would like to assign some code to a command button that performs the
following:
Reference’s the column I12 through to I205.
If the cell is greater than 0 it will then copy the e-mail address from
the cell in column H,
I would then be able to paste all the e-mails addresses into an e-mail
to contact all the users. I don’t know if excel has functionality to
open and e-mail and put all the addresses in or not. If not it can just
generate a list that I can paste in.
Any help really appreciated!
Thanks.
--
scriblesvurt
------------------------------------------------------------------------
scriblesvurt's Profile:
http://www.excelforum.com/member.php...o&userid=24399
View this thread:
http://www.excelforum.com/showthread...hreadid=390111