Hello,
I have a list with the following columns:
Status (data-can be Active,Expired,Upcoming)
contract number
vendor name
Each friday i want sharepoint to send me one mail which list all contracts status Expired their contrtact number and vendor
and also a mail same as above but for upcoming
it should all be combined in one mail instead of a seperate mail
i am a newbi so a detailed explanation is most welcomed.
thanks in advance.