Need an email to be sent to individual users

Evening 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.

Unfortunately I couldn't able to attached the file as site is not allowing me add. But the format will be like below:

eg: a email should go to individual user in the below format

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 Any email ID ( As it is not allowing me to add email throwing an error)
S234 222 Me.Sam Distribution 01-Aug-18 12-Aug-18 Expired Any email ID ( As it is not allowing me to add email throwing an error)

Could someone please help me.

Thanks.
RVR.

Is there anyway to add the file?

Hi,

Thanks for the quick reply, i have attached the file. As mentioned earlier its a rough data as original data cannot share for security reasons.
Please let me know if you need additional information or i missed anything which will help you guys.

Regards.
RVR.

Hi,

It aint worked, giving an error.

Regards.
Rvr

Hi Guys,

Any further luck on this, as said am not a master in VB/Macros so i need some help in resolving this.

Thanks for support.

Regards.
RVR.

Have attached the error.

Good Morning.

Thanks for your email , please find the error as requested.

Regards.
RVR

Is this any good for your needs? I am was a bit unclear as to the exact requirements of the email you want to send, I presumed you wanted the information from the table from the relevant line on the data:

Please Login or Register  to view this content.

Afternoon Both.

Thanks for your time and information. Both codes worked perfectly fine.

Thanks to the forum for helping the learners.

Regards.
RVR.