Hi there,
I'm trying to get Excel to dictate Outlook to close an Outlook email window. Basically I have a macro in a workbook that is stored centrally (a) that is called from an Excel workbook email attachment (b) that the user opens. The email attachment (b) is a completed form and the info is ripped from it and put into A - a central database (where the running macro is).
I'd like to 'clean up' after this data has been extracted. I've already closed the form workbook (b) from the macro in workbook A. But how can I close from Excel the email window displaying the email that holds the attachment (b)?
Just a footnote - I was hoping the macro would need to cycle through open Outlook windows to check for the title of the window which is basically the subject. If it matches string A then close it.
I'm trying to get Excel to dictate Outlook to close an Outlook email window. Basically I have a macro in a workbook that is stored centrally (a) that is called from an Excel workbook email attachment (b) that the user opens. The email attachment (b) is a completed form and the info is ripped from it and put into A - a central database (where the running macro is).
I'd like to 'clean up' after this data has been extracted. I've already closed the form workbook (b) from the macro in workbook A. But how can I close from Excel the email window displaying the email that holds the attachment (b)?
Just a footnote - I was hoping the macro would need to cycle through open Outlook windows to check for the title of the window which is basically the subject. If it matches string A then close it.
