Add File From Folder To Currently Open Email / Draft

[Citanaf]

Hello All,

I used the search function extensively but I did not find my questions asked specifically. Most of the "Attach file from folder" questions involve drafting an entirely new email and is executed from the main outlook window. I would like to attach my files to a currently open email / draft. This macro would be executed on the already open email and the files would attach directly to that email.

Below is the code I am working with. The code runs but does not attach anything to the open email. I believe the file paths are correct as the code does not throw an error when passing the line.

There is an IF statement in the code as I send out an AM / PM report so the time of day is relevant. If I had to guess, the issue has something to do with the OApp/OMail objects. Perhaps I need to be setting them equal to the current object? Not sure, just a thought.

Thank you

Please Login or Register  to view this content.

[skatonni]

Set OMail = OApp.CreateItem(0) creates a mailitem.

Without OMail.Display you never see it.

Please Login or Register  to view this content.

[Citanaf]

Hi Skatonni,

Thank you for your help. The code is working now. I spent a few hours to save myself 10 seconds a day.. haha, it will pay off eventually.

Marked as solved.