import emails from outlook to access vba

[live2ride]

i would like to import outlook emails to access 2007 using late binding so i dont have to set ODBC connection or link tables.



i would like to import outlook folder "Inbox/SD" to access table 'tblOutlookSD"
simple subject and body is all i need from Outlook
i went through many forums but couldnt get anything to work, any help would be greatly appreciated

[June7]

Review https://www.accessforums.net/import-...ble-26078.html

[live2ride]

i saw that forum previously and tried using the code in there but it couldnt get it to work

[June7]

That's about the best I have and as you can see from my post, not quite satisfactory.

[live2ride]

i used the code from this website http://www.techrepublic.com/blog/how...-using-vba/119 but unfortunately it doesnt do much good since each user would have to do the same thing on their computer, for what its worth maybe someone can benefit