Solved

Scripting Export /  Import of Outlook 2003 Rules

Posted on 2013-01-24
5
1,348 Views
Last Modified: 2013-01-25
Using a script how would I do the following?

1.  Detect if a user has configured rules in Outlook 2003.

2.  Export from the rules from Outlook 2003 and then Import these rules in to Outlook 2010.

Thanks
0
Comment
Question by:epmmis
  • 2
  • 2
5 Comments
 
LVL 16

Expert Comment

by:choward16980
Comment Utility
0
 

Author Comment

by:epmmis
Comment Utility
Appreciate the prompt response, but your answer does not help me.   I would like to use a script to do the detection/export/import.  I have over 1000 outlook users to be migrated. Being able to use a script would ease the migration process.

At a minimum is the script to detect if rules are present or not.  If the rules must be manually transferred having a script would expedite identifying the users with rules.
0
 
LVL 76

Expert Comment

by:David Lee
Comment Utility
Hi, epmmis.

Unfortunately, Microsoft didn't add the ability to manage rules from code until Outlook 2007.  Outlook 2003 and earlier doesn't have the ability to read/create rules from code.  There is a third-party utility called Outlook Redemption that I believe will work to at least detect the rules.  Redemption is a DLL that gives programmers/scripters access to settings/features that aren't available through Outlook's programming interface.  I can put something together if you want to give that a shot.
0
 
LVL 16

Accepted Solution

by:
choward16980 earned 500 total points
Comment Utility
My apologies...  I completely overlooked that.  It's hokey, but:

Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.AppActivate "outlook"
WshShell.Run "outlook", 9
Wscript.Sleep 3500
wshshell.sendkeys "{ESC}"
WshShell.SendKeys "%T"
WshShell.SendKeys "l"
Wscript.Sleep 2000
WshShell.SendKeys "{Tab}"
Wscript.Sleep 500
WshShell.SendKeys "{Tab}"
Wscript.Sleep 500
WshShell.SendKeys "{Tab}"
Wscript.Sleep 500
WshShell.SendKeys "{Tab}"
Wscript.Sleep 500
WshShell.SendKeys "{Tab}"
Wscript.Sleep 500
WshShell.SendKeys "{Tab}"
Wscript.Sleep 500
WshShell.SendKeys "{Tab}"
Wscript.Sleep 500
WshShell.SendKeys "{Tab}"
Wscript.Sleep 500
Wscript.Sleep 1000
WshShell.SendKeys "+{END}"
Wscript.Sleep 1000
WshShell.SendKeys "%O"
Wscript.Sleep 500
WshShell.SendKeys "%E"
Wscript.Sleep 1000
WshShell.SendKeys("{%}userprofile{%}\Desktop")
WshShell.SendKeys "{ENTER}"
WshShell.SendKeys("{%}username{%}-Rules")
WshShell.SendKeys "{ENTER}"
Wscript.Sleep 500
wshshell.sendkeys "{ESC}"
wshshell.sendkeys "{ESC}"
WshShell.SendKeys "%F"
WshShell.SendKeys "x"
Wscript.Quit


Creates a username-rules files of exported rules on the users desktop
Worked on Server 2003 with Outlook 2003....   But, requires user login and launch...  Best (I) can do.
0
 

Author Closing Comment

by:epmmis
Comment Utility
Your best was pretty darn good.  
While it was not exactly what I wanted I can make it work for us.
Thanks
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Email signatures have numerous marketing benefits. Here are 8 top reasons to turn your email signature into a marketing channel.
If you don't know how to downgrade, my instructions below should be helpful.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

728 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now