Solved

need to automate the subject line with the date sent

Posted on 2014-03-31
8
406 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 51

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
Problems using Powershell and Active Directory?

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

 
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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

710 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