Solved

Issues with Outlook VB script

Posted on 2014-01-02
14
453 Views
Last Modified: 2014-01-03
I posted a question last month which was answered in a timely manner.

It worked so well, I actually set the script to run on two computers running Outlook: Outlook 2010 and 2013.

As of today, the script has quit working.  No updates were made to either machine.  Only Outlook was restarted.  Now with it no longer working, I'm scratching my head trying to figure out why it would stop, especially on two different computers.  

I admit when I set the script up initially, I never stopped Outlook again until today.  

What I want is when Outlook forwards an email, it changes "FW" to "FWD".  I have checked my macro security where the default was selected but went so far as to set it to allow all macros to run.  Since that didn't fix it, I set it back to Notifications for digitally signed macros, all other macros disabled.
0
Comment
Question by:shonadle
  • 7
  • 7
14 Comments
 
LVL 76

Expert Comment

by:David Lee
ID: 39753473
Can you post the code or a link to your previous question so we can see the code?
0
 

Author Comment

by:shonadle
ID: 39754042
I did.  It's in my first post but here is another link to the other question:

http://www.experts-exchange.com/Software/Internet_Email/Q_28323742.html#a39752638
0
 
LVL 76

Expert Comment

by:David Lee
ID: 39754073
Oops.  Sorry, I missed the link.
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 76

Expert Comment

by:David Lee
ID: 39754077
The code is in place in the ThisOutlookSession module, macros are enabled, and the code isn't working.  Is that correct?
0
 

Author Comment

by:shonadle
ID: 39754089
Yes.  It was working GREAT!  Then I restarted Outlook (first on the 2013 version).  When I did that, it stopped working.  Tried repasting code over and over, to no avail.  

Played around with the macro settings, to see if setting them really low would pop it back in.  No.  I then looked at the outlook 2010 version because it also had been working to see if there was a difference.  That's when I noticed it had quit working.  It was restarted during this experiment too.

I did not do any Windows updates in this time.  Both are running Windows 7 with one on Office 2013 and the other on Office 2010.
0
 
LVL 76

Expert Comment

by:David Lee
ID: 39754104
What is Outlook's macro security set to?
0
 

Author Comment

by:shonadle
ID: 39754135
Originally "Notifications for digitally signed macros, all other macros disabled.  Since this happened I set it down to Enable all macros.  I also checked the Apply macro security settings to installed add ins on and off.
0
 
LVL 76

Expert Comment

by:David Lee
ID: 39754148
Ok.  Add this code to what you already have in ThisOutlookSession.  Once you've added the code, close and restart Outlook.  Tell me what happens after restarting.

Private Sub Application_Startup()
    MsgBox "Macros are enabled."
End Sub

Open in new window

0
 

Author Comment

by:shonadle
ID: 39754575
No, sorry.  Tried it in both the 2013 and 2010 versions, still shows the sent email as "FW" instead of "FWD".  (I did restart Outlook by the way).
0
 
LVL 76

Expert Comment

by:David Lee
ID: 39754753
That wasn't designed to fix the problem, It was to test and see what's going on.  What happened when you restarted Outlook?  Did you get a dialog-box?  If you didn't, then macros are not enabled despite the fact that they are set to be enabled.
0
 

Author Comment

by:shonadle
ID: 39754800
oh sorry. I didn't get a dialogue box.
0
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 39755013
Ok.  Here's what I recommend.  

1.  Close Outlook
2.  Delete Outlook's code file.  All Outlook macro code is stored in a single file.  That file is named VbaProject.OTM.  The file will be in the c:\Users\<username>\AppData\Roaming\Microsoft\Outlook folder (where <username> is your username).  Go to that folder and copy that file to another folder (so you have a backup), then delete the file.
3.  Start Outlook.
4.  Open the VB editor and re-add the code.  Include the code I posted above.  We'll use it to determine if macros are working.  Outlook will automatically create a new VbaProject.OTM file.
5.  Close and restart Outlook.

Let me know what happens.  When you restart Outlook you should get a dialog-box.  If you do, tell me what it says in the dialog-box.
0
 

Author Comment

by:shonadle
ID: 39755022
Ok, well I did not get a dialog box.  However, the script is working again.  It changed Fw to FWD.  

I'm going to go back in and take out that second script and see if it still works.
0
 

Author Comment

by:shonadle
ID: 39755026
Yes it still works.  

I find it odd that this issue happened on two different computers with two different versions of Outlook.  It's almost like that VB script had gotten corrupted and needed to be removed.  (which luckily you told me how to do).
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question