Outlook parse incoming mail VBA
Posted on 2011-10-27
Can someone tell me how to code VBA in Outlook.
I am accustomed to VBA in Excel, I do custom ribbons and addins etc, userforms, but have no idea how to put VBA code into Outlook.
I want Outlook to parse the body, subject, to and from fields of every incoming email and save the text to a SQL database. I know how to send commands in SQL language, that bit is no problem.
Then I want Outlook to save the email message in a Windows folder (just like when you go Ctrl + C on an email and then Ctrl + V in a Windows folder and it pastes the email message as a file).
If you need more info let me know.
Outlook versions are all either 2007 or 2010.