Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-12-2020, 02:14 AM
EdwinK EdwinK is offline Sort mail on basis of repeating messages Windows 7 32bit Sort mail on basis of repeating messages Office 2013
Novice
Sort mail on basis of repeating messages
 
Join Date: Oct 2020
Posts: 1
EdwinK is on a distinguished road
Post Sort mail on basis of repeating messages

An electronic lock sends a mail when:


1. its battery is low AND
2. someone uses the lock

That means: until the battery is replaced and the lock is reset mails are coming in. (sometimes 10-20 times within an hour)

step 1.The mails come in to a mailbox called e.g. lock@company.com
But whe need te mail as a incident-call in our FMIS, so:
step 2. - by hand - whe move the mail to another mailbox (e.g. Servicedesk@company - INBOX).
step 3. Our Fmis system pulls the e-mail from that INBOX and creates a incident-call from the mail.
step 4. remove all the following mails from that lock to the Deleted Items, because we want only one incident-call in the Fmis-system

I would rather not do step 2 and 4 by hand.
step 2. make a rule that moves the email to the right box (easy) but:
step 4. Can Outlook recognise: I already had that mail today, so this time another rule applies: move this one to Deleted Items.

Difficulties:
We have around 500 of these locks. So within a short time we can get these emails from different locks. The mail is the same but for the content.

From: "Server@Locks.nl"
subject: "low-battery warning"
content:"Low battery warning [date][time] from lock [X]"- where X is the name of the lock. So: date and time

So outlook needs to look in the content and make a dicision: Today: this Lock-name is new OR not new
new: message goes through (to INBOX service@company.com)
not new: message goes to deleted items (to DELETED ITEMS)

Is that possible, and how?
Reply With Quote
 

Tags
rules; outlook; variables



Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 365 mail boxes will not keep sort bulrush Outlook 1 07-29-2020 04:03 AM
InfoPath 2013 In a Repeating Section condition a field of a nested repeating section kirvin08 Misc 0 03-15-2016 04:52 AM
cannot send new mail messages Alan.bailey Outlook 0 10-23-2015 09:03 AM
Sort mail on basis of repeating messages Mail merge repeating decimals issue jmorris33 Mail Merge 2 01-10-2015 11:54 PM
Sort mail on basis of repeating messages VBA to automatically sort items based on Mail Merge field taylorblu Word VBA 3 09-08-2014 09:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:48 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