Results 1 to 13 of 13
  1. #1
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Outlook Date & Time

    14:18 02/21/2001 - Sent
    In Microsoft Word, by pressing Alt + Shift + D you get the
    date, and the T will give the time. Alt + Shift + T
    This will not work on Outlook, In the Task Manager,
    I type a lot of notes starting with the date Example : 02/21/01
    Is there a quick way, or could someone write a tool bar selection,
    ( I have looked ) in VB for the DATE, Time, or both,
    this would really be a time saver for me.
    I do not know if a Macro could be written for this,
    and I do not know if you can do a macro on Outlook ???
    I know there are some really sharp people out there,
    but could you get someone to something this easy ?
    I gusee it would be easy for someone in the Know.... Richard
    Another example is in Notepad, press F5 and 14:19 02/21/2001
    there it is Time and Date, kinda backwards for me, but it is on
    This stuff is way outa my league ... I am an Electrician, by trade.... Help anyone ????? :-)
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Outlook Date & Time

    As I recall, the inability to assign keyboard shortcuts in Outlook is one of its lingering inconsistencies with the rest of Office.

    I don't use Tasks, so I'm not sure of the best way to do this. I see that you can pop up a form, and if you can pop up a form, you can add a button to run a VBA procedure, in which case your options are basically unlimited. Someone here undoubtedly can come up with the code and explain how to add a button. What field do want it to paste into? Or do you just want to pop it into the clipboard so you can paste it with ctrl+v ?

  3. #3
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Outlook Date & Time

    Richard,

    Can you indicate which version of Outlook you are using.
    If it's Outlook 2000, it should be pretty easy to do (not having ever done it though!)
    If it's any of the earlier versions, it may not be too feasible.

    Gary

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Outlook Date & Time

    Hi Richard,
    If you're using Outlook 2000, then something like this should work:
    Sub InsertDate()
    Dim myItem As TaskItem
    Set myItem = Me.ActiveInspector.CurrentItem
    With myItem
    .Body = Date & .Body
    End With
    End Sub
    You can assign this to a button on one of the menu bars (right-click on the menu-bar, choose Customize, then select Macros and drag the button onto a toolbar. If you then choose Modify Selection and change the Name to '&Z Insert date' (without the apostrophes) you can then activate it by pressing Alt-Z (assuming you don't already have a menu item with Z underlined in its name)
    Hope that helps.
    PS Just in case: To paste that code in, press Alt-f11 from within Outlook then paste it into the blank code window.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Date & Time

    I was hoping to just mouse click on a button and the date would be put in where the cursor is at the time, example in the MS Word Shift+Alt+D will insert the Date at the cousor
    position. I would like to click on a button when the cursor
    is in the Task typing section and it place the date in for me. ???? I am using the MS 2000 outlook
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  6. #6
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Date & Time

    16:04 02/25/2001 - Can you see where I made a mistake ?
    I tried pasting this into a macro, when I tried to use it I got the message : Compile Error
    invalid use of me key word ???

    15:51 02/25/2001
    Hi Richard,
    If you're using Outlook 2000, then something like this should work:
    Sub InsertDate()
    Dim myItem As TaskItem
    Set myItem = Me.ActiveInspector.CurrentItem
    With myItem
    .Body = Date & .Body
    End With
    End Sub
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Outlook Date & Time

    The Me keyword is only valid in class modules, which include the modules behind forms. In a standard routine, it will always throw an error.

    Rory will have to explain where to paste the code to make it work.
    Charlotte

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Outlook Date & Time

    Hi Richard,
    Sorry for the delay in responding (and the fact I left out the important bits in the first place!)
    You'll need to open Outlook and press Alt+f11 to open up the VBEditor, double-click on ThisOutlookSession and then paste the code into the (presumably) blank module that appears on the right.
    Then open up a new task, right-click on the menu bar of the task form and choose customize, choose Macros from the Commands tab and drag the InsertDate macro from the right window onto the tasks toolbar. You can then customise it as I said before to use shortcut keys.
    (Incidentally, I checked and you don't actually need the Me keyword for it to work, so if you've already done all of that, try simply removing the Me keyword and see if it works then)
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  9. #9
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Date & Time

    Hey thanks for responding at all. I have just copied your reply into a text file with the other information, I will try it out ASAP ... AND thanks for even taking the time to
    answer the question.... Richard
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  10. #10
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Date & Time

    Thanks for the response, I got an update I am wanting to try now... Richard
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  11. #11
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Date & Time

    I am missing something here, I went into the VB Editor
    I have a blank page with (2) pull downs, General, (Declarations)and below you have an immediate, I do not see
    the ThisOutlookSession ??? I do have the copy of the code you sent :
    Sub InsertDate()
    Dim myItem As TaskItem
    Set myItem = Me.ActiveInspector.CurrentItem
    With myItem
    .Body = Date & .Body
    End With
    End Sub
    But I still do not know how to put it in where you are talking about ? I am so sorry for being so dumb on this stuff, I even contacted a person who knows VB, but he said
    he did not know VBA ??? I am trying to read your directions and I am going to send them on to the person who said they were going to do this for me but never did .... Thanks again for the attempt at helping.... Richard
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  12. #12
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Date & Time

    Do not know how but this is working, but it jumps to the top of the page, I would like it to happen where the cursor is at the time the macro is launched ???
    Would also like to have one for the time and at the current position of the cursor ???? I am having to go to the tools Macro, Macros and select this one from the menu at this time but at least I am close ....
    Sub InsertDate()
    Dim myItem As TaskItem
    Set myItem = ActiveInspector.CurrentItem
    With myItem
    .Body = Date & .Body
    End With
    End Sub
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  13. #13
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Outlook Date & Time

    Hi Richard,
    If you change the line
    .Body = Date & .Body
    (which should insert the date at the beginning of the notes field) to
    .Body = .Body & Date
    then it will insert the date at the end of whatever you currently have in the notes field, which I think is what you're after?
    To get the date and time, change the Date bit to Now.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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