import from attachment from outlook

  • Thread starter Thread starter Moon Walker
  • Start date Start date
M

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…….
 
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…….
Click to expand...

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