![]() |
|
#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!
|
|
|
|
Similar Threads
|
||||
| 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 |
Real Time calculations
|
wgutshall | Excel | 3 | 07-10-2015 08:44 AM |
| Display txt in real-time | Prostrelov | Word | 13 | 06-21-2014 08:48 AM |