Macro to send email using lotus notes based upon cell value

I have a spread sheet and i want to send a email to a persons email add if the date of a proposed action is 3 days away from being complete

Example file attachedco2.xlsm

Can anyone help with a macro

I think all you need to do is change this line:

Please Login or Register  to view this content.

Spot on thanks was a long night missed that one point

Glad to help out.

1 more question if i wanted to do this line by line with different emails can this be done

Something like this may work. Untested though.

Please Login or Register  to view this content.

Will your recipient always be Range("F3") or will it also be in the loop? If so then that line would have to change as well. Range("F" & i).value

Ok have attached a file an need this

if Cell V7 8 9 10 an so on is less than H1 i need it to send a mail in lotus notes using email from cell O7 8 and so on can you help. some code is in sheet but now stuck
test.xlsm

Maybe:

Please Login or Register  to view this content.

spot on thanks

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.