PDA

View Full Version : Enable Macros to use VBA - Other Options



jnix612
12-13-2017, 09:15 AM
I work for the federal government. They don't allow me to change the Macro Settings in email that would allow me to use a VBA code to download multiple attachments from email. Even though part of my job is managing and processing 1,000-1,500 documents that arrive via email. I have automated using VBA code in so many areas of this process except this one step.

Question, is there another option I can use that does not require VBA in Outlook?: pray2:

jnix612
12-13-2017, 12:03 PM
Never mind. Somehow I stumbled across a way to bypass the security. I was going to Trust Center to enable macros. I decided to try once more, I added the developer tab and at some point a box popped up for me to enable macros. I said yes and the VBA code is working. I don't feel like I'm bypassing security because surely they would have blocked this feature in all areas. Plus I'm allowed to use VBA code in Excel.