import from attachment from outlook

[Moon Walker]

Dears,

Daily I receive many emails via outlook and in each email there is an excel
attachment

Now I open each of those attachments and copy its contents to access table,
one by one,
and this process take a lot of time, so my question is: is there any VBA
code can import these attachments automatically from outlook and put them in
the mentioned table.


Thanks in advance…….

 

[pietlinden]

Dears,

Daily I receive many emails via outlook and in each email there is an excel
attachment

Now I open each of those attachments and copy its contents to access table,
one by one,
and this process take a lot of time, so my question is: is there any VBA
code can import these attachments automatically from outlook and put them in
the mentioned table.

Thanks in advance…….

Create an import specification
Loop through the messages in your inbox
Loop through the Attachments collection of the Messages object
Process each attachment...