so since i have looked this up and figured it out (i know... there isn't much to figure it out, but there it is) i figured i should blog about it so i can quit looking it up somewhere else.
basically i just needed to hit a button/hotkey int outlook and have it insert the time/date stamp and my name and a couple of pipes to just divide everything up. no biggy. but if you never create macros and do this once every two years, it's a bit of a pain to remember how. this is for outlook 2007, i think 2003 was a bit different.
basically you just create a new macro, and then you can add a button and/or bind a hotkey to that. here's this sub will insert something like the following:
2010-05-03 10:34:54 AM EST | Roy Ashbrook |
I have a prefix of vbcrlf on the line so i can just go to the end and hit the button. i use this to update tasks in outlook so i can remember when i added something. well, i guess not 'remember' since i just read it.
anyway, here is the the sub that i use.
Sub datetimename()
' in word 2007 for this to work you have to go to
' tools/references and add a reference to word
Dim d As Word.Document
Dim s As Word.Selection
Dim v As String
v = vbCrLf & Format(Now(), "yyyy-MM-dd HH:mm:ss AM/PM") & " EST | Roy Ashbrook | "
'Set d = Application.ActiveInspector.WordEditor
Set s = Application.ActiveInspector.WordEditor.Windows(1).Selection
s.TypeText v
Set s = Nothing
'Set d = Nothing
End Sub
Wednesday, May 26, 2010 10:20 AM