copy data from outlook attached excel file into a local one

gmayor · #5 09-17-2014, 11:46 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel 2013 local file contact to shared path when i open it	osama6767	Excel	3	05-28-2014 06:29 AM
How to Copy data from Outlook mail and Paste it in a Excel sheet?	padhu1989	Outlook	0	09-11-2012 04:07 AM
How to copy automatically data from Excel file to Word file?	fuchsd	Word	6	10-25-2011 05:52 AM
Problem with MS Outlook when open email with attached file	moniros	Outlook	0	03-01-2009 12:50 AM
Outlook xp slow when Browsing to attached a file	jmelgar1	Outlook	0	09-23-2008 01:49 PM