Microsoft Office Forums - View Single Post - Subject Line Editing Problem.

Thread: Subject Line Editing Problem.

View Single Post

Old

04-19-2017, 12:54 AM

gmayor

gmayor is offline

gmayor uses Windows 10

Windows 10 gmayor uses Office 2016

gmayor uses Office 2016

Office 2016

Expert

Join Date: Aug 2014

Posts: 4,144

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

Default

A simple macro will change the subject of a selected message e.g

Code:

Sub ProcessSubject()
Dim olMsg As MailItem
Const strSubject As String = "ABC123 - "
    On Error Resume Next
    Set olMsg = ActiveExplorer.Selection.Item(1)
        olMsg.Subject = strSubject & olMsg.Subject
        olMsg.Save
lbl_Exit:
    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

Reply With Quote