Solved

need to automate the subject line with the date sent

Posted on 2014-03-31
8
401 Views
Last Modified: 2014-04-16
HI

Is it possible to set up a routine so that the date is put at the beginning of the subject line on every email before it’s sent or reaches the recipient.

we use outlook 2007 to 2013 via exchange 2007.
0
Comment
Question by:total123
  • 4
  • 3
8 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 100 total points
ID: 39966214
Hi,

pls try

This code in the ThisOutlookSession Module after inserting it close Outlook and reopen it
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
    Item.Subject = Format(Date, "dd.mm.yyyy") & ": " & Item.Subject
End Sub

Open in new window

Regards
0
 
LVL 76

Expert Comment

by:David Lee
ID: 39967137
@Rgonzo1971 - I recommend adding an

Item.Save

to your code.
0
 

Author Comment

by:total123
ID: 39972310
can I ask what an item save would do ?

this did work on testing, thank you
0
Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
LVL 76

Expert Comment

by:David Lee
ID: 39972323
Item.Save saves the change to the subject line.
0
 

Author Comment

by:total123
ID: 39972330
ok and how would that look on the macro ?
0
 
LVL 76

Assisted Solution

by:David Lee
David Lee earned 55 total points
ID: 39973420
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
    Item.Subject = Format(Date, "dd.mm.yyyy") & ": " & Item.Subject
    Item.Save
End Sub

Open in new window

0
 

Author Closing Comment

by:total123
ID: 40004953
spot on, thank you
0
 
LVL 76

Expert Comment

by:David Lee
ID: 40004996
You're welcome!
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
This video discusses moving either the default database or any database to a new volume.
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question