Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 04-07-2015, 07:41 AM
kcm5153 kcm5153 is offline Outlook VBA Script Windows 8 Outlook VBA Script Office 2013
Outlook VBA Script
Join Date: Mar 2015
Posts: 3
kcm5153 is on a distinguished road
Default Outlook VBA Script


I do not know how to write VBA script at all. I was hoping someone could set me up with the basic bones of a script I would like to run in the background of my outlook. The rules are complicated so I would like directions on how to copy sections of the script to apply it to more people.

I have 13 sales managers with many different store numbers. I would like to set up a rule for outlook to look for a variety of numbers tied to different sales managers then forward the message to them and copy the forwarded email into a common folder.

For example,

9066, 9067, 9180, 9186, 1234, 5678, etc. belong to Sales manager, I would like outlook to look for one of these numbers ex. 9066 (not 9066111 or 1119066, I want it to be exclusive to 9066) if it finds one of the number strings to then scan the email for 1 1(Not satisfied at all) - 5(Very satisfied)

If it finds both the store number and the
1 1(Not satisfied at all) - 5(Very satisfied) I want to forward the message to the correct Sales Manager ex. and put in a common folder ex. FW Surveys so I know what has been sent out. But I want this rule to be applied to multiple Sales Managers.


9066, 9067, 9180, 9186, 1234, 5678 belong to
9056, 9123, 9157, 9407 belong to
9131, 9149, 9174, 9220 belong to

I want to be able to set this up for 13 different sales managers

Reply With Quote
Old 04-07-2015, 11:41 PM
gmayor's Avatar
gmayor gmayor is offline Outlook VBA Script Windows 7 64bit Outlook VBA Script Office 2010 32bit
Join Date: Aug 2014
Posts: 3,862
gmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to behold

Without seeing the message format, this is very much a question of shooting in the dark. Where for example are the numbers to be found in the message? How is the message formatted with respect to the satisfaction string?

Take a look at which covers some of the principles involved.
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes
Reply With Quote

script, vba

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bolding in script ksigcajun Word VBA 10 02-23-2015 08:29 AM
Adapt a script used in Word to highlight words, to work in Outlook? flatop Outlook 5 07-15-2014 01:07 PM
Help with VBA script nsyrax Word VBA 1 01-18-2014 03:38 AM
Outlook VBA Script Outlook Script Help TheInfinetGroup Outlook 1 03-02-2013 07:43 AM
[ask] about VB Script + Ms. Project anak_baru Project 2 03-10-2009 01:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:53 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd. is not affiliated with Microsoft