Results 1 to 4 of 4
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Message Subject TimeStamp (Outlook 2007)

    I'm working with a person who wishes to add the Sent Timestamp information to the subject line.
    This is because he drags his messages out to folder in the operating system. Since multiple messages may have the same subject, the time stamp ensures each message is saved uniquely.
    He is doing this for long term storage of correspondence by project.
    However in Outlook 2007, it is doable, but awkward.
    I was wondering if anyone else out there uses the same system and has any suggestions.

    TIA
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Message Subject TimeStamp (Outlook 2007)

    <P ID="edit" class=small>(Edited by JohnBF on 15-May-08 05:30. Added code sample.)</P>Catharine,

    > in Outlook 2007, it is doable, but awkward.

    What is being done right now? Would a macro to save the message and add the timestamp to the saved file name, rather than to the subject line, be an acceptable solution? Are the messages saved to drive in *.msg format?

    Would this starter code be of use?

    Sub savemessagewithsentonstamp()
    Dim strTargFldr As String, strFileName As String
    Dim lngC As Long

    On Error Resume Next
    strTargFldr = Replace(CreateObject("Shell.Application").BrowseFo rFolder(0, _
    "Folder for saving selected files", 0, 17).Items.Item.Path & "", "", "")
    If Len(strTargFldr) < 3 Then Exit Sub

    If ActiveExplorer.Selection.Count Then
    For lngC = 1 To ActiveExplorer.Selection.Count
    With ActiveExplorer.Selection(lngC)
    If .Class = olMail Then
    strFileName = .Subject & " " & Format(.SentOn, "yyyy-mm-dd_Hh.Nn.Ss") & ".msg"
    strFileName = strTargFldr & Replace(Replace(Replace(strFileName, ":", ""), "/", "-"), "*", "")
    .SaveAs strFileName, olMSG
    End If
    End With
    Next lngC
    End If
    End Sub
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Message Subject TimeStamp (Outlook 2007)

    Yes, the messages are saved to the drive in .msg format (this is automatic, when you drag out of Outlook and into the file system). I'm not sure what he will think about a code solution.
    I suggested .pst file for each client - located with the clients' files and using Outlook rules to sort the incoming mail.
    However, he is worried about long term accessibility of the messages.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Message Subject TimeStamp (Outlook 2007)

    It would be easy to build a macro to add a timestamp each selected message subject, but then why stop there, why not do the entire operation in one fell swoop?

    I personally agree with your idea of one PST for each client (and a good backup system). If your client is concerned about PST stability, and long-term storage, s/he might be better off using another storage approach such as converting all the messages to text. Thunderbird has the capability of importing Outlook PSTs into a message base, but I'm not sure that it would retain attachments.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •