View Single Post
 
Old 10-12-2020, 02:14 AM
EdwinK EdwinK is offline Windows 7 32bit Office 2013
Novice
 
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