Merging two macros

[Alteregoist]

Hello everyone,

I need help with merging two macros in one another.

The first macro extracts XLS* attachments from selected e-mails in outlook and saves them in a specified directory.
The second macro writes down mail subject, sender and date sent inside a file.

What I need is a macro that extracts XLS* attachments from selected e-mails in outlook, writes down mail subject, sender and date sent inside the attachment and save it in a specified directory.

Here is the first code:

Please Login or Register  to view this content.

Here is the second code:

Please Login or Register  to view this content.

I tried my best and failed. I'm grateful for any help.

Thanks in advance!

[patel45]

did you try adding to the first macro (before end sub)

Please Login or Register  to view this content.

[Alteregoist]

did you try adding to the first macro (before end sub)

Please Login or Register  to view this content.

That would probably work in some cases, but ExportToExcel saves the info in a specific file outlookitems.xls

I need the macro changed a bit so instead it opens the extracted xls attachment, make the modifications there, save and continue the cycle.

[Alteregoist]

Bump.

this is not too time consuming, just a little missing piece of code.

Again, thanks in advance for help.