The “run a script” function stopped unexpectedly in Outlook2007

Status
Not open for further replies.

botter_bao

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
The run a script function stopped unexpectedly in Outlook2007

Hi pals,

I encountered a problem that I found the function of "run a script" is disabled suddenly in my outlook2007, here is the details:


At the beginning, the "run a script" func works fine, and I'm very happy. But about half day later, I found it refused to work! I think I did nothing except adjusted the priority of the rule (by using the up and down arrows). So I changed back its position to the top, but not recovered. I also reboot my computer, and also failed.

Then I started a new rule which is a very simple stub:

Sub test(Item As Outlook.MailItem)
MsgBox "haha"

End Sub


The result is disappointing -- it doesn't work either. I found a similar question before, the link is Problem Getting Outlook 2007 Running VBA Script. As bob-the-destroyer said, it might be a problem of the outlook it self... I just wonder if any more actions could cause this failure? Do I have any more method to troubleshoot this problem? Thanks very much!

P.S. I've changed the Security level to "Warnings for all macros".
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Re: The run a script function stopped unexpectedly in Outlook2007

I'd set macro security to low for testing.

The rule was not disabled but the script wasn't running, correct?

Do you get a lot of mail? If so, rules can be problematic - they may stop working for a time then restart. ItemAdd is a little more efficient and newmailex is better. How to process incoming messages in Microsoft Outlook
 

botter_bao

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Re: The run a script function stopped unexpectedly in Outlook2007

I'd set macro security to low for testing.

The rule was not disabled but the script wasn't running, correct?

Do you get a lot of mail? If so, rules can be problematic - they may stop working for a time then restart. ItemAdd is a little more efficient and newmailex is better. How to process incoming messages in Microsoft Outlook

Hi Diane,

Thanks very much for your quick help, and I'll try it as your guidance. The rule is not disabled, just seems the scirpt isn't triggered by the coming of the new mail (I think the rule works fine since I used the "stop processing more rules", and the incoming mail stayed in the Inbox therefore).

And the traffic of the mail is very low, actually the mail for which I wanna use this script rules will arrive once a week : )
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Re: The run a script function stopped unexpectedly in Outlook2007

It not so much how often the script runs but how much mail needs to be tested by the script. Because you are presumably restarting outlook now and again between runs, one would expect it to work. At this point I'm out of ideas. Sorry.
 

botter_bao

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Re: The run a script function stopped unexpectedly in Outlook2007

It not so much how often the script runs but how much mail needs to be tested by the script. Because you are presumably restarting outlook now and again between runs, one would expect it to work. At this point I'm out of ideas. Sorry.

Hi Diane,

Thanks a lot for your continuous help on this trouble, and I got this problem resolved by updating the certificate that suggested from this thread: outlook 2007 vba code won't run in Windows 7 - Microsoft Community , FYI.

---------------------------------------For a workaround, in the Office folder you will find selfcert.exe which will enable you to create a certificate for your own macros.

Having done that, set the macro security in Outlook to provide warnings for all macros. Allow the macros at the security warning when you see it.

From the Outlook VBA editor > Tools > Digital Signatures, add your newly created signature to the project.

Close Outlook saving the project at the warning.

Re-open Outlook and you will again get a security prompt for the vbaproject. From that dialog choose the option to trust items from the publisher (your certificate).

---------------------------------------BTW, my Outlook version is 2007 SP3 (12.0.6661.5003), my OS version is Win7 (6.1.7601 SP1 build 7601). Thanks for your kindly help again.:cool:
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Re: The run a script function stopped unexpectedly in Outlook2007

Yeah, that is why I don't sign macros and use the low / no warning setting - I'm changing them too often and re-signing them is a PITA.
 

botter_bao

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Re: The run a script function stopped unexpectedly in Outlook2007

Yeah, that is why I don't sign macros and use the low / no warning setting - I'm changing them too often and re-signing them is a PITA.

Hi Diane,

I found the root cause that why I set the macro security to low but also failed to make the script activated yesterday... That's really foolish -- I forgot to restart the Outlook -_-! And I tried it again just now, and found the script also works fine without any certificate loaded. Thanks a lot for your reminder!
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
G Save attachment run a script rule Outlook VBA and Custom Forms 0
E Having some trouble with a run-a-script rule (moving mail based on file type) Outlook VBA and Custom Forms 5
Aussie Rules Run a Script on an Incoming Email OK and then the Email reverts Outlook VBA and Custom Forms 0
Y Outlook 2013 Run A Script Outlook VBA and Custom Forms 4
B Outlook rule run a Script doesn't work Outlook VBA and Custom Forms 1
B Wanting to run a script that will filter any body that has a russian link in it. Outlook VBA and Custom Forms 5
Bri the Tech Guy Registry Tweak to make "Run a Script" Action Available Outlook VBA and Custom Forms 2
Bri the Tech Guy Run Script rule not running for newly arriving messages Outlook VBA and Custom Forms 25
Vijay Error in rule- Run a script Using Outlook 1
Vijay Run script doesn't work in outlook Using Outlook 1
Diane Poremsky Run a Script Rule: Send a New Message when a Message Arrives Using Outlook 2
oliv- How to Run a Script IN AN ADDIN with Outlook's Rules and Alerts Outlook VBA and Custom Forms 2
L Run a Script Rule doesn't work Using Outlook 5
X Outlook script to run excel data Outlook VBA and Custom Forms 1
D RUN SCRIPT WHEN OUTLOOK IS CLOSE Outlook VBA and Custom Forms 1
L Cannot run script from rule Outlook VBA and Custom Forms 7
O modify vba to run it as script rule Outlook VBA and Custom Forms 8
P How many subs can run in one outlook VBA script Using Outlook 5
Xueying run a script in rules, first time succeed, failed afterwards Outlook VBA and Custom Forms 3
P Vba script including macro appears in rules but wont run Outlook VBA and Custom Forms 6
Jeff Rott Diane Question on "Use in a Run a Script Rule" Outlook VBA and Custom Forms 1
J Outlook 2007 Rules & VBA: How to run a script on a report message (ReportItem) Using Outlook 14
L Outlook 2007 Macro to Run a Script From a Contact Form Using Outlook 41
E run script fails suddenly Using Outlook 3
L Run A Script not listed in rules wizard Outlook VBA and Custom Forms 12
L Run script rule not exectued for first few mails Outlook VBA and Custom Forms 2
U Outlook 2019 VBA run-time error 424 Outlook VBA and Custom Forms 2
D Outlook 2013 Macros only run in VB editor, not in drop down or button Outlook VBA and Custom Forms 10
D We're sorry but outlook has run into an error Using Outlook 6
M White square in body of Outlook Messages (O2016 Version 2012 32bit Click To Run) Using Outlook 4
C Auto Run VBA Code on new email Outlook VBA and Custom Forms 1
A Apply Selected Emails to outlook rules and Run Rules Using Outlook 5
B VBScript doesn't run on Recipient Email Outlook VBA and Custom Forms 2
A Run-time error '430' on certain emails when trying to set "Outlook.mailitem" as "ActiveExplorer.Selection.Item" Outlook VBA and Custom Forms 2
S Outlook Custom Form Scripting only working when clicking on "Run this form" Outlook VBA and Custom Forms 2
O Outlook 2016 This rule will only run when you check your email in Outlook.... Using Outlook 4
B run scripts Using Outlook 1
A Run time error 424. object required in outlook 2013 Outlook VBA and Custom Forms 10
Dave A Run macro on existing appointment when it changes Outlook VBA and Custom Forms 1
O Run macro automatically at sending an email Using Outlook 11
P errors appear every time I run SCANPST Using Outlook 3
S VBA Macro - Run-time error '424': object required - Help Please Outlook VBA and Custom Forms 3
P Run Time Error 91 when linking contact to task in VBA Outlook VBA and Custom Forms 1
O Having rules run on old mails noved to inbox Outlook VBA and Custom Forms 8
J Custom form code doesn't run Outlook VBA and Custom Forms 2
J VBA Run When Reply Outlook VBA and Custom Forms 4
O VBA to Run Font Change on Outlook Startup Outlook VBA and Custom Forms 4
D Creating an outlook session from Access vba but run silently. With A specific profile Outlook VBA and Custom Forms 1
Diane Poremsky Using Scanpst in Outlook Click to Run Using Outlook 0
B Can't run macro from QAT when emailing from Acrobat Outlook VBA and Custom Forms 0

Similar threads

Top