I want to read specific informations about the email sender.
I read my emails with a for each loop with assigned variables that contains the mail.sender, mail.subject etc.
And then im typing all that information into a .txt file so i filter it and put the necessery in a datatable that i build.
Later on when my datatable rows is filled then i want to write range to an excel file.
You will have to find specific patterns by seeing multiple emails like the one you have shared above if you can see in signature you can easily get Telephone, mobile email and website from string manipulations on body of email. You are already getting from email address
Lets say that ONLY the body will change of the email. The signature is and will always be the same place of the email (at the bottom). How do we manipulate that?
There should be a way to split the email into an array of strings. For example you could use a " " character to split. Because you know who the email has come from (mail.sender) you could build some manipulation of the email address (assuming its firstname.lastname@company) and then find the name in the body of the email. Once you have the position of the name, you have located the signature and can assume that the following info is phone numbers/websites etc. There are some regex expressions you can use to identify the email addresses and phone numbers, however I’m still learning regex myself so can’t help you out with that I’m afraid!