Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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

Hi,

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, jane@example.com. 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. jane@example.com 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.

Example

9066, 9067, 9180, 9186, 1234, 5678 belong to jane@example.com


9056, 9123, 9157, 9407 belong to mike@example.com
9131, 9149, 9174, 9220 belong to susan@example.com

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

Reply With Quote
  #2  
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
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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 http://www.gmayor.com/extract_data_from_email.htm 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 www.gmayor.com
Reply With Quote
Reply

Tags
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 04:59 AM.


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