![]() |
#1
|
|||
|
|||
![]() I have some experience in coding VBA, some in Excel, but for years now mostly in Access. I have never written code/macros in Outlook till yesterday. I copied some code I found and pasted it in a .bas file using notepad. I then imported it into Outlook VBA successfully and gave it a test run with lots of breakpoints so I could follow it. After a few tries I got a partial result, which was an Excel file full of email data. I need help with the code, but today I am unable to even run it. I get a message "Macros are disabled in this project etc..."which is confusing because I was able to run this yesterday. Any suggestions? |
#2
|
|||
|
|||
![]()
p.s. I tried changing the settings in the Trust Center, but the Macro Settings are all grayed out and can't be changed.
|
#3
|
||||
|
||||
![]()
Outlook is rather more fussy about security than other Office applications. You need to digitally sign the project - see http://www.gmayor.com/create_and_emp...gital_cert.htm
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#4
|
|||
|
|||
![]()
Tried all that, but still no success. My next step is to work through my local I.T. security folks. It's becoming increasingly unproductive to pursue this. The odd think is it let me run this code one day and the next it wouldn't. I went to another laptop and it let me run the code there at least once. I will try again Monday to see if I still can.
|
![]() |
Tags |
macros |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
laurieli | Office | 7 | 01-17-2016 08:56 AM |
How to automatically enable macros upon opening the Word? | laurieli | Word VBA | 2 | 12-22-2015 02:46 PM |
How to enable PowerPoint Macros? | delete123 | PowerPoint | 3 | 03-27-2012 06:56 AM |
Outlook macros for Hyperlinks | outlookmacro | Outlook | 0 | 06-13-2011 02:01 PM |
Enable/Disable Macro in Outlook | JimDandy | Misc | 0 | 05-11-2006 06:17 AM |