Solved

need to automate the subject line with the date sent

Posted on 2014-03-31
8
407 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 52

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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Check out this step-by-step guide for using the newly updated Experts Exchange mobile app—released on May 30.
To show how to generate a certificate request in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Servers >> Certificates…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

617 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