I am new to VBA and am trying to figure out how I could accomplish the following:
I have an excel template that is filled out by many employees and e-mailed daily. Data from worksheet is e-mailed as XML in an email body.
What I am trying to do is get this data into Access DB.
I guess I would need to:
1) get a reference to the inbox
2) iterate through the emails and parse the xml
3) create a recordset and add the values from the xml in 2 above
Can someone please provide some samples of VBA code of how would one achieve this?