Morning All,
Looking for some assistance/help. I have a sheet with multiple rows which contains details of all the service requests raised by users (find the attached, however changed the details for security purpose). I will get these details once the requests are expired, so i need to send an email to the user notifying about the expiry of the request.
So what am i looking here is In column H i have email ID, i need a code/formula button once i click it need to send an individual email saying the "Request raised has been expired would you like to extend or close" in body of the email.
Hi,
your request has been expired, would you like to extend or close the request.
Request Id Employee No. Employee Name Service Name Service Start Date Service End Date Status Email ID
S123 111 Mr.Rao Email 28-May-12 31-Aug-17 Expired [email]xxx.yyy@gmail.com[/email]
Could someone please help me.
Thanks.
RVR.