Forum Discussion
Jonny_Davies
Jan 18, 2023Copper Contributor
Excel Sheet Coding
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
- peiyezhuBronze Contributorsend text message with formula。
=webservice("http://e.anyoupin.cn/eh3/?send~smtp.126.com~email address removed for privacy reasons~password123~email address removed for privacy reasons~remider~1month")
//http://e.anyoupin.cn/eh3/?send~smtp address~sender email发件人邮箱~sender email password邮箱密码~receiver email~email title~邮件内容email contents