#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
It might be possible to make an Outlook rule to perform most of (or all) the steps.
Another approach would be to use macro software to automate the steps. I've used Macro Express to automate these kinds of things. These projects are not super difficult, but this one is probably not the best project for a beginner to take on. To get a sense of what might be involved, see this recent thread from an online Macro Express forum, which describes a similar kind of problem: Challenge: a macro to "decide" what to do with an email message - Macro Express and Macro Express Pro - Macro Express Forums |
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 |
Mail merge repeating decimals issue | jmorris33 | Mail Merge | 2 | 01-10-2015 11:54 PM |
VBA to automatically sort items based on Mail Merge field | taylorblu | Word VBA | 3 | 09-08-2014 09:52 AM |