I am new in VBA world and i have a question about connecting MS outlook to MS access (2007 or 2010). let me explain what i want exactly by telling you what kind of project i wanna do.
I have an access database with a lot of data and tables, when i receive any email with certain subject like if i receive an email says in the subject line "Emp 1232221" then outlook when see any email with subject start with "Emp" a VBA code should go to MS access table called "employees" and get all the data belong to employee no "1232221" put them in excel sheet and reply back with this sheet as an attachment.