Here’s a quick guide on how to create your own Outlook shortcuts (not Outlook keyboard shortcuts) on the desktop or Quick Launch bar so that you can easily create a new email message, add new notes, add new contacts, or create new appointments without having to open the Outlook window at all! I find these shortcuts better than the Outlook keyboard shortcuts because those still require you to. I've always wanted to do this: I get an email message and I want to create an appointment from the the message. It's a simple task and I found that this was one of the goals of Chandler in the book that I'm reading right now,. Incidentally, I just met Scott at Scoble's Geek/Blogger dinner in San Francisco last week. From the book, I learned that the software architecture that the Chandler team was using to accomplish this task was very complex. I looked into the Outlook 2007 UI I did not find this feature. Last week I visited a customer and the engineering manager there asked how to do this. The beauty of Outlook is that it is programmable! In about an hour, I was able to write a short VBA Macro that does the following: • If the current item is an email, create a new appointment item • Copy the categories, body, and subject • Copy the attachments • Add the sender as a meeting participant • Add each email recipient as a meeting participant • Each To: participant will be a required • Each CC: or BCC: participant will be optional I then added the macro to my quick launch bar for an Outlook message and it worked! I have attached the macro for all of you to try out. Enjoy, Michael 5/24/2007: Updated macro to fix bug with copying attachments. I think I figured the earlier one out (just shows how much I have been waiting for something like this!). Accomplished it by changing the security settings (Tools->Macro->Secuirty->Programmatic Access). However, I have another problem. Since I have numerous filters set up, I normally have my Unread Mail window always open (in fact that is my default, not Inbox). Stabilize: Stabilize shaky videos recorded by GoPro Hero 6/5 Black or new. Best mac editing for gopro 4. I added your macro to the toolbar here, and tried to invoke it once I saw the message I want displayed in the reading pane. I did not click the message to open in a separate window. I get this error message: Run-time error ’91’; Object variable or With block variable not set. However, if I have the message open in a separate window, I can invoke the Macro either from the Unread Mail window, or from this separate window without any issues. Is there any fix for this? OK so I fixed my last question. Here is a hacked version of your code that you can use in a rule as a script. I will be using this for all email that I send to myself so I would get calendar reminders for the quick one liner reminder emails I send to myself. Sub NewMeetingRequestFromEmail(item As Outlook.MailItem) Dim email As MailItem Set email = item Dim meetingRequest As AppointmentItem Set meetingRequest = Application.CreateItem(olAppointmentItem) meetingRequest.Body = email.Body meetingRequest.Subject = email.Subject meetingRequest.Start = email.SentOn meetingRequest.End = email.SentOn meetingRequest.ReminderSet = True meetingRequest.ReminderMinutesBeforeStart = 1 meetingRequest.Save End Sub. First, thanks, this gets me most of the way to where i need to go. I’ve been playing with this macro to try to see if I can get it to read the simple body to pull out names, dates and a subject to be used in the appointment but I’m not sure if the methods I’m using are correct. I’ve been trying to use the.IndexOf and Substring functions to cut up the string and define variables but I seem to have a mismatch with my variables. Here’s the mess I’ve made, any help? Dim X As Integer Dim Y As Integer Dim name, reason, bodystring As String bodystring = meetingRequest.Body X = bodystring.IndexOf('#') X = X + 2 Y = bodystring.IndexOf('$') Y = Y – 2 name = bodystring.Substring(X, Y) X = ' X = Y + 4 Y = bodystring.IndexOf('!'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |