Improve company productivity with a Business Account.Sign Up

x
?
Solved

Issues with Outlook VB script

Posted on 2014-01-02
14
Medium Priority
?
470 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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
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 1500 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Though there are a few manual ways to import PST files to Office 365 , third-party PST to Office 365 import tools are preferred over them due to various reasons.  Consequently, many tools or services are available for the same. Here, we pick the to…
An Outlook data file aka PST is prone to corruption due to various reasons. A corrupt PST file is always inaccessible. Also, you may lose all your crucial mailbox content at any time. So to fix this corruption and protect the mailbox content from be…
If you are looking for an automated tool which can generate reports for Outlook emails and other items from PST file, then you can go for Kernel PST Reporter tool. The reports which are created by this tool are helpful to analyze and understand PST …
Watch the software video of Kernel Import PST to Office 365 tools which can easily import PST and OST files to Office 365 for bulk mailboxes. The process of migration is simple and user can map source and destination mailboxes and easily import data…

606 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