bnfkru4567
New Member
- Joined
- Aug 20, 2017
- Messages
- 10
Hi All
I need your Excel Excel/Outlook VBA expert to help.
I knew how to build up outlook VBA to detect new email with attached file (i.e. PDF file) coming in the specific folder but have the following problem :
The email has attached file that is PDF file with password protected. (I know the password to open it). Under the PDF, there is link/icon and use mouse to click on it and then a small window coming up to choose either open or save the excel file or not into computer. Of course, "save the file" into computer.
However, how could I write up excel/ utlook VBA to do all the above steps automatically ?
I am using Outlook 2013.
Thanks for your help in advance
I need your Excel Excel/Outlook VBA expert to help.
I knew how to build up outlook VBA to detect new email with attached file (i.e. PDF file) coming in the specific folder but have the following problem :
The email has attached file that is PDF file with password protected. (I know the password to open it). Under the PDF, there is link/icon and use mouse to click on it and then a small window coming up to choose either open or save the excel file or not into computer. Of course, "save the file" into computer.
However, how could I write up excel/ utlook VBA to do all the above steps automatically ?
I am using Outlook 2013.
Thanks for your help in advance