Import Excel attachment from outlook using VBA.

Hello. I am trying to use VBA to pull an excel attachment from Outlook and save it in a folder. The e-mail is received once a day and always has the same name, as does the file name. The destination where it will then be saved will always the same as well. The mailbox where the file is received is one of many I have access to, so has a specific name. I have seen some example code to do something similar, but have not been able to successfully adapt it. Is anyone able to help please? Any help or advice much appreciated.

 

Thanks.

By: Richard

Leave a Reply

Your email address will not be published. Required fields are marked *