Excel Sheet Coding

Copper Contributor

Hi all. 

I use an excel sheet for my work, I use it to log projects we quote on a daily basis. I currently put a date of when we receive the job but I would like it to automatically email me that specific information from the line when that date becomes out of range (say 1-2 months old). I assume that with excel and outlook being linked there’s a way to do this?

 

is it possible? It’s basically just a format that sends me a reminder to chase up the job, as it’s not really a sheet that we go back to the older jobs if necessary as it’s done on a month by month basis.

 

happy to listen to any suggestions, I’m not very good when it comes to coding so any help is appreciated. 

Thank you 

1 Reply
send text message with formula。

=webservice("http://e.anyoupin.cn/eh3/?send~smtp.126.com~email address removed for privacy reasons~password123~em...")

//http://e.anyoupin.cn/eh3/?send~smtp address~sender email发件人邮箱~sender email password邮箱密码~receiver email~email title~邮件内容email contents