![]() |
#1
|
|||
|
|||
![]()
All requests come into my company to a single email where multiple users can review them and follow up. We need a way to let the other people in the department see that a particular email has been dealt with - color coding, removal to a separate folder, etc. Is anyone aware of a way I can mark/move etc a message so others will see it has been addressed? Or another tool in Office that could help to accomplish it?
Our hope is to resolve this within Outlook - otherwise we will likely need to create a shared live list and each user will be scrolling/searching the list for every email - and the list needs constant updating after each email has been reviewed. This searching and updating of a separate list are many more steps then just clicking a setting to show a message has been resolved to all recipients. I hope that makes snese; let me know if you need any more info. |
#2
|
||||
|
||||
![]()
Based on your comments, create a new category 'Completed' and apply it to messages that are completed. Perhaps better still, create a new mail folder, again called 'Completed' (or whatever suits you better) and move the completed messages to it. The following Outlook macro will categorise the message as completed and move it to a sub folder of Inbox called 'Completed', which it will create if not already present,
Code:
Option Explicit Sub CompletedMsg() Dim olMsg As MailItem Dim olFolder As Outlook.Folder Dim bExists As Boolean Const sFolderName As String = "Completed" 'the name of the Completed folder On Error Resume Next Select Case Outlook.Application.ActiveWindow.Class Case olInspector Set olMsg = ActiveInspector.currentItem Case olExplorer Set olMsg = Application.ActiveExplorer.Selection.Item(1) End Select For Each olFolder In Session.GetDefaultFolder(olFolderInbox).folders If olFolder.Name = sFolderName Then bExists = True Exit For End If Next olFolder If Not bExists = True Then Set olFolder = Session.GetDefaultFolder(olFolderInbox).folders.Add(sFolderName) End If olMsg.UnRead = False olMsg.Categories = "Completed" 'optional olMsg.Move olFolder lbl_Exit: Set olMsg = Nothing Set olFolder = Nothing Exit Sub End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
![]()
Many thanks. I feared a resolution within Outlook was unlikely. At a glance your approach strikes me as an excellent one but one which I may not be able to carry out perfectly. I'll make an effort to implement this change in the morning (6 hours) and if I struggle I'll reply here. Thanks again for your time!
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Share contacts but keep the email address hidden from users, use these contacts to send a email | Dispatcher7 | Outlook | 0 | 03-23-2021 05:30 AM |
How can I access an Outlook email address that was created some time ago? | Tom Prendergast | Outlook | 0 | 02-03-2020 05:02 PM |
Can I prevent certain users from seeing email address of certain users in the recipient/sender field | sevenpcb | Outlook | 0 | 08-21-2017 10:11 AM |
![]() |
wgutshall | Excel | 3 | 07-10-2015 08:44 AM |
Display txt in real-time | Prostrelov | Word | 13 | 06-21-2014 08:48 AM |