在日期过期时向用户发送电子邮件 [英] send email to user when date expired

问题描述

嗨朋友
我想在过期日期临近
的前一周自动向用户发送电子邮件 我有2个表1)登录
2)post_property
登录表具有电子邮件"列
post_property具有到期日期列
请帮助....


此邮件向用户发送通知.

hi friends
i want to send email to user automatically one week before when expire date near
I have 2 table 1)login
2) post_property
login table has email column
post_property has expire date column
plz help.....


this mail send to user a notification.

推荐答案

User below query to extract the records whose expire date is nearing to expire in next week:

Select Email From [login] Inner Join post_property
On [LOGIN].ID = post_property.ID
Where DATEDIFF(D,GetDate(),[expire date])<=7

这篇关于在日期过期时向用户发送电子邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！