Copy email body content into certain cell in Excel

I am trying to copy the certain email body content and put into certain cells in excel. For example:
In the first screenshot1, trying to copy XXYY from name and put in cell D3 in screesnhot2, then copy the contact:0123456 to cell G3(as in screenshot 2) followed by Remarks if any to the cell in excel.

Not only that, if the name belong to certain department, it is not necessary be in the same cell… For example, if XXYY is from department:HR, the name will be in cell D9 instead and the contact:0123456 will be at cell G9.

screen1 screen2