I'm very new to VBA, but have been programming with vb.net for several years now. What I would like to do is grab an attachment (excel), suck out all the information in that excel file and enter it into a SQL database. I have no clue how to do that using VBA and Outlook. I'd love to be able to have this done automatically when the email comes in, but if the user has to click a button to go through the inbox to grab the specific emails/attachments, that's alright. I just don't know how to get that attachment info to the database.
(I'm using Office 2007 and SQL 2005)
(I'm using Office 2007 and SQL 2005)