Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Issues with Outlook VB script

Posted on 2014-01-02
14
Medium Priority
?
464 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

722 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