Automatic emailing

Hello,

I am trying to get excel to email a sales rep when their client account is nearing expiration. I have been through all of the forums and help sites trying to figure this out and I keep getting the same error, "error 91: object variable not set yet," I definitely did set it. Additioanlly, the mnacro deosnt recognize when the value of the specified cell goes above the limit i set it at. my code is reproduced below. I would appreciate any and all help. This is my second day ever dealing with VBA so thank you in advacne for your patience in dealing with me. I have attached the excel file as well.

regards,
Jacob

Please Login or Register  to view this content.

And the email code is

Please Login or Register  to view this content.

Smart ledger 1.0.xlsm

thank you. Works great now. 1 final question. How would I get the macro to run everytime I save the document?

Thanks!