Move Excel files to an Outlook folder

I am trying to develop coding in a macro (or something else) that would auto move ms excel files into an Outlook folder. Can anyone assist?

Hello ninja0059,

It is possible to do this, but more inofrmation is needed to provide you with a solution. Will Outlook being running when the macro is invoked? Which Folder will the file be saved to in Outlook? Are you saving the Active Workbook?

Thanks,
Leith Ross

Leith,

Outlook will be running when the macro is run and the hopes is to save the active workbook to a public folder in Outlook and yes, save the active workbook. I will need to repeat this exact scenario for each of the active workbooks saving it to different Outlook folder.

Hope this helps.

Hello ninja0059,

I haven't forgotten about you. If all goes well tomorrow, I should have some code for you.

Sincerely,
Leith Ross