Want to get the email id of the Caller_id (task ticket creator)?

[SN_2023]

Hi all,

Once the task (ticket) is processed and completed, I will close the task as "Closed Complete". After closing the ticket I will fill the notes along with the task creator email id in order to send email to him/her. Finally click the "Update" button. I am accessing the servicenow from Excel. I want to get the email id to send to task creator. How can I achieve that? How can I get the email id of the task creator? or Are there any other methods to accomplish this requirement?

thank you all.

[Ankur Bawiskar]

@SN_2023 

Sorry it's confusing unless you share few screenshots.

[SN_2023]

Hi Ankur,

If we type "@" in Work_Notes text box, the pop up will ask/raise to type the user or select the email id of the task creator. It is enough to type the name after the symbol "@", it will populate the full email_id. From there the Work_Notes details will be sent to that email id. Since I am accessing the servicenow task from my Excel VBA 2019 through REST API, I can't select the email_id from the popup. So, how can I get the email id from servicenow.

if you require more details, please let me know

Thank you.