Copy outlook e-mail to Excel

[RodrigoFinguer]

Good morning guys

I really need your help..
I tried to find a VBA for me but i didn't, and those i found i didn't understand at all! hahaha

I would like a VBA to copy 4 specific things from na e-mail, there are: "CNPJ", "E-mail", "Phone" and "Name" (CNPJ and E-mail are the most important, and the easier i would say)

I really need your help, there are so many e-mails to copy these items.
Thank you!!

 

[RodrigoFinguer]

One more thing..Genererally the "CNPJ" comes in this format: 12.345.678/0001-00 and the e-mail Always have the "@" sign.