Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 11-07-2020, 07:47 AM
AlanCantor AlanCantor is offline Sort mail on basis of repeating messages Windows 10 Sort mail on basis of repeating messages Office 2019
Competent Performer
 
Join Date: Nov 2020
Posts: 134
AlanCantor is on a distinguished road
Default

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
Reply With Quote
Reply

Tags
rules; outlook; variables

Thread Tools
Display Modes


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 09:42 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