Mail subject number to excel macro

[Raju Radhakrishnan]

Hi,

I wanted a macro which would copy and paste all the numbers which will be in the subject of a mail

For Ex: TP-doc number 1234567 is the subject in the mail which is in outlook.

I want the macro to copy it from the outlook and paste it into any newly formed excel.

Thanks

[Raju Radhakrishnan]

I have attached an attachment. Actually what happens is we get close to 150 mails such kind and we have to match the same numbers with a different file with numbers. So its very tedious

Reply if any more information is needed