Macro/VBA to extract 'subject' field from email

Vote count:

0

I'm trying to get some information from the incoming emails from work. Basically i'm trying to get an allocation program to automatically sort emails based on new or opened tickets. The opened tickets are assigned a tracking number and the whole process is done by reply in outlook, so after the first -new- email, every other email is assigned to the same colleague until closed. The number in the subject is a 8 digit number, something like 91387949 (always beginning with 9).

I want to create an excel file containing the 'from' field, the date and time of the incoming email, and most importantly to extract the number from the 'subject' field.

I tried modifying the code found here (Outlook macro to collect/extract data from "Subject field" of numerous messages into a text file) but i'm not good with macros/vba :)

Could someone please help out with modifying the code? Or a new one?

Thanks a lot!

Romeo

asked 1 min ago

Romeo Vaetus

1

Macro/VBA to extract 'subject' field from email