Download & Store attachment in Excel from Outlook

[UnysonElliot]

My experience with VBA is very limited but I get six emails a day that have to be combined in excel once a week. I'm looking to try to automate this process using VBA. I know it is possible to open an attachment from an outlook email using VBA but would need to add to the script to look for the next email and append the data to the current excel file.

Can anybody help/point me in the right direction of the correct script to use and how to adjust the script?