Quote:
Originally Posted by s_samira_21
But Where should I paste this code? ThisOutlookSession or a Module?
|
The code goes in an ordinary module.
You can test it by selecting a message and running the following:
Code:
Sub Test()
Dim olMsg As MailItem
Set olMsg = ActiveExplorer.Selection.Item(1)
ProcessAttachment olMsg
End Sub
Note that you will have to change the paths and the filename of your target workbook, and of course add the code to transfer whatever it is that you wish to transfer from one sheet to the other.