Saving Attachments from Gmail

[mikebrewer]

Hi all,

I have a situation where I would like to download attachments from Gmail using Access. Story is that at the end of everyday, we receive an email with a text file of tickets. Usually the person saves the attachment to a folder, clicks a button and then it gets imported into our accounting system. I would like to automate this process. I just don't know how to check Gmail with VBA and then save an attachments if it hits certain criteria.

Has anyone done anything similar?

Thank you!

 

[leanpilar]

Im interested to, I managed this with creating an account extra in my business account and make a rule in gmail toforward that specified mail to my outlook account.
Then I can connect access to outlook folder and check for new mail because I get every week a new one, but I need to manualy download the mail in my folder tu upload in access. I read somewere that vba in outlook on event new mail can save attachment so probably I can call from access if I made a module in outlook... butnow I dont have time to do this for save me 1 minevery week