How to auto truncate a message to forward with Outlook Rules

Status
Not open for further replies.

ksorrells

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Hello,

I need to be able to auto truncate an email message before forwarding it. Here is the scenario. I receive certain alerts from my telephone system. I need to be able to forward these alerts to cell phones. I don't need to send the entire body of the email (most cell phones cut off the important part because of too many characters anyway). The email subject is always the same so I can use Outlook rules to forward, but I need a script to truncate the message to just the info I need.

The subject is always: ShoreWare Event Notification: Switch: (1319)

The body of the email is always:

Computer: Servername

Version: 12.15.6700.0

Type: Warning

Date: 8/3/2010 9:53:33 AM

Source: ShoreWare

Category: (1) Switch

Event ID: 1319

Description:

Switch Switchname: Emergency Services Call to 911 on port 10.42.107.80 from user (Username) at (extension)

All I need to forward is the Description.

Any suggestions would be appreciated!
 

Forum Admin

Senior Member
I'd suggest using an SMS addin - they can limit to 160 characters but not pick out a line within the message.

I'll ask around and see if anyone has a ready-to-use script that does this - if so, the run a script rule is what you'd use.
 

Forum Admin

Senior Member
It is always the last line?

If so, from http://www.slovaktech.com offers this as starter code:

If it’s always the last line in Body the Body can be retrieved as a string and then parsed into lines using Split(sBody, vbCRLF) where sBody is the body string. That would return an array and the last array member is the return value:

Function ReturnLastLine(Item As Outlook.MailItem) As String

Dim sBody As String

Dim sLines() As String

Dim ret As String

sBody = Item.Body

sLines = Split(sBody, vbCRLF)

ret = sLines(UBound(sLines))

ReturnLastLine = ret

End Function
 

ksorrells

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
I'd suggest using an SMS addin - they can limit to 160 characters but not pick out a line within the message.

I'll ask around and see if anyone has a ready-to-use script that does this - if so, the run a script rule is what you'd use.
Thanks for checking:cool:
 

ksorrells

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
It is always the last line?

If so, from http://www.slovaktech.com offers this as starter code:
Thanks Ken, I don't work with scripts at all so this is new to me. Yes, it is always the last line of the email that has the info I need. I will work with this and see if I can get it to do what I need.

Thanks again!

Kathy:eek:
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
R Auto display of new email does not work on non-default account Outlook VBA and Custom Forms 0
B Outlook 2016 Auto-archive creates new folder Using Outlook 4
J Edit auto-complete list in Outlook 2016+/365? Using Outlook 0
P Auto assign shared mailbox Outlook VBA and Custom Forms 1
M Outlook 2010 Problem with OutLook 2010 32 bit, after Windows Auto Update Using Outlook 3
P [SOLVED] Auto remove [EXTERNAL] from subject Using Outlook 6
Z Add text to auto-forwarded e-mail Outlook VBA and Custom Forms 4
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
Q Prompt button to auto turn on Out of Office Outlook VBA and Custom Forms 3
P Auto Insert Current Date or Time into Email Subject Outlook VBA and Custom Forms 2
S Messages moved / deleted by auto-archive are not synchronized to exchange Exchange Server Administration 8
B Outlook 2010 is Auto Purging when not configured for that Using Outlook 1
M VBA to auto forward message with new subject and body text Outlook VBA and Custom Forms 8
A Auto Accept Meetings from the General Calendar Using Outlook 3
R auto send email when meeting closes from a shared calendar only Outlook VBA and Custom Forms 2
S auto-mapping mailboxes in outlook impacting an ost file? Exchange Server Administration 2
M Auto expand Distribution List Before Sending Email Outlook VBA and Custom Forms 1
M Auto-export mail to Excel Outlook VBA and Custom Forms 2
Ms_Cynic Auto-pasting email content in calendar appt? Using Outlook 2
R How Do I insert images in and Auto Reply Using Outlook 3
S Received mail as part of DL, need to auto-CC the same when replying Outlook VBA and Custom Forms 5
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 10
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 0
P Auto scroll to specific folder in Folder Pane Outlook VBA and Custom Forms 3
C Auto categorize duplicate subjects Outlook VBA and Custom Forms 11
N Auto-complete - block select emails Using Outlook 3
C Auto save outlook attachments when email is received Outlook VBA and Custom Forms 1
J HELP- Rule to auto strip prepend from external emails Using Outlook 0
S BCM Auto Backup Data and Customizations BCM (Business Contact Manager) 6
G Auto accept meeting request for non primary account Outlook VBA and Custom Forms 1
J Outlook Rules - Changing auto-submit address in multiple rules, according to rule name Outlook VBA and Custom Forms 0
E Outlook Form - Voting Responses Not Auto Processing If Form Contains Any Code Outlook VBA and Custom Forms 0
J Auto Forward - Include Attachment and change Subject depending on original sender Outlook VBA and Custom Forms 3
K Extract email address from body and auto-reply outlook Using Outlook 1
S Auto move search results to folder Outlook VBA and Custom Forms 0
E Outlook 2010 disable date auto-complete Using Outlook 2
C Auto subject,name,email,deferred Using Outlook 2
ashcosta2 Auto Reply rule based on speficied time Outlook VBA and Custom Forms 0
B Auto Preview Attachment in Inspector Reading Pane Outlook VBA and Custom Forms 1
Z Auto Forward Using Outlook 4
M can anyone recommend an alternative to DS auto-followup? Using Outlook 2
S Rules to auto redirect Using Outlook 5
B Auto Save of Attachments from Multiple Emails and forward attachments to user group Outlook VBA and Custom Forms 1
A Auto Insert of filename when selecting 'Remove Attachment' Using Outlook 1
C Auto Add a PDF to an outgoing Email, based on a rule Using Outlook 2
B Auto open PDF Outlook VBA and Custom Forms 0
P Is it possible to convert address book to "Auto-Complete List" (NK2)? Using Outlook 5
B Auto name checking upon Tab or Click off To field(s) Using Outlook 19
J Auto Accept Notifications from a shared icloud calendar? Using Outlook 4
B Auto scan/send Outlook VBA and Custom Forms 5
Similar threads


















































Top