Extracting an attachment from within an attached 'Outlook Item'

[blimboy]

Hi All,

Sorry if this has been asked already, If it has I've not been able to find it.

I have a shared inbox in outlook that receives a mixture of emails with attached .csv files, I have built a macro to extract the .csv (if they match certain keywords), the macro then merges them into a master file, emails it and saves a backup of the master file to a folder and deletes all of the temp files, it then moves the processed emails to an archive folder in outlook.

After completeing the macro I have discovered that there are a handful of messages that hold an 'Outlook Item' as an attachment which in turn holds the .csv file i'm after.

I'm looking for some code to extract the 'Outlook Item' into the mailbox so it will get picked up by my macro.

Any help would be gratefully received.

Cheers
Nik

 

[blimboy]

I should probably add that the macro is held within an excel sheet, not within outlook.

Cheers
Nik