Hello,

I am a BIG novice to programming in VB and I need help creating a macr
in excel.

Let me try to explain what I am trying to do:

The Macro should do one of the following:

- Send an email to the person in column 7 if the value in column 1
is ="over 60 days"
- Send an email to the person in column 10 if the value in column 1
is = "over 45 days".
- If column 19 is empty, then no email should be sent
- Do this automatically when the spreadsheet is open


In addition to this I want only one email to be sent to each perso
(ie. if it sends out a new email everytime the spreadsheet is open th
people will get annoyed :)). I suppose this could be accomplished b
having the macro also check a hidden column to see if this person ha
been already emailed or not.

I hope you people can help me out. :)

Thanks a lo

--
sa
-----------------------------------------------------------------------
sae's Profile: http://www.excelforum.com/member.php...fo&userid=1538
View this thread: http://www.excelforum.com/showthread.php?threadid=27000