Dear Diane,
first of all thanks a ton for all the valuable advice! You don't know how much time you saved me and my colleagues at work
Now, there is one thing that I cannot get right, so here's my case study:
a) Every day I get 50-100 e-mails from an automated form, with the following elements in the body:
Kontakt osoba jozukić p25
Dodatni tekst mislim da bi bilo dobro da imamo barem jedan komad na nivou firme,štop prekidač,meni konkretno treba za antaru,ali vidim da ide i na druga vozila
Broj proizvoda 700424
Šifra dobavljačevog artikla 700424-VAL
Korisnik :
ciakp25
so, my goal is to extract the information from every single field into an excel sheet, everything in its column. The potential issue is the last one where it's not in the same line, but the pattern recognition is "Korisnik :", and the result is in another line.
So far I've been combining (unsuccessfully) these two threads:
Use a macro to copy data in Outlook email to Excel workbook
Use RegEx to extract text from an Outlook email message
But when I enter and edit everything in the project (both in object and add the module - and my excel sheet is opened in Documents under Korisnik.xlsx), it doesn't work.
The e-mails always have the same sender (noreply@carparts-cat.com) and the same receiver (nabava@ciak-auto.hr), out of which I already created a rule to move it to a specified folder. Of course, if I use the run rule as script I need to make it the only rule, so this one that I mentioned cannot co-exist with "run rule as script". Or could it?
Additional level of complexity might be that I'm already getting orders everyday from
noreply@carparts-cat.com, but that's related to another email account (narudzbe@ciak-auto.hr). Also, this e-mail
nabava@ciak-auto.hr which I'm receiving is an e-mail group on MS Exchange.
All in all, if the first step can be done (extract the patterns to Excel), I don't mind the clutter in my Inbox. Even if I cannot transfer this "Korisnik :", it's not an issue.
If you find time in the next week or so, I would really appreciate your help.
It's office 2010, and MS Ex account (dominik.leko@ciak-auto.hr).
Thanks, best regards,
Dominik