Creating an Appointment in Outlook 2010 Installation

Creating an Appointment in Outlook 2010
Creating an Appointment in Outlook 2010 Part II

You can download MGoogleCal.zip

Here are the steps to install the code.

  1. Download the zip file from the link above
  2. Unzip the four files and make a note of where they are
  3. Open Outlook 2010
  4. Press Alt+F11 to open the VBE
  5. Press Ctrl+R to show the Project Explorer

    Yours will no doubt look different than mine, but you should have a project called VbaProject.OTM.

  6. Right click anywhere in that project and choose Import File…
  7. Import the two .bas files and the one .frm file (you have to do them all separately)

  8. Edit (thanks Steffan): Choose Tools – References from the menu and add a reference to Microsoft VBScript Regular Expressions 5.5
  9. Choose Debug – Compile from the VBE menu
  10. Choose File – Save VbaProject.OTM from the VBE menu
  11. Close the VBE
  12. Right click on the Ribbon and choose Customize Quick Access Toolbar
  13. Choose Macros from the Choose commands from: dropdown
  14. Add MakeGoogleAppointment to the Customize Quick Access Toolbar listbox

  15. Press Alt+4 to open the form. My icon is fourth on the QAT so Alt+4 will run the macro. Yours may be in a different spot, so use the number for your situation. If you just press Alt, you’ll see the numbers on the QAT.
  16. Create an appointment

  17. Click OK

  18. And you’re done.

Important: Don’t forget this is mostly untested. Install at your own risk. And let me know what doesn’t work.

3 Comments

  1. Steffan says:

    Perhaps you covered this earlier, but I needed to add the reference for “microsoft vbscript regular expressions 1.0″ and “microsoft vbscript regular expressions 5.5″ before the compile would complete. It kept telling me “user defined type not found” for rxNarrative and rxMatches in Private Sub tbxNarrative_Change. Once that reference was added, it compiled properly.

  2. Dick Kusleika says:

    Oops, forgot about that one. Edited the instructions. Thanks Steffan.

  3. David C says:

    Very nice idea. Have not tested it yet… I already have some code to create a meeting request based on an existing mail (it becomes a simple appointement if you leave the “To” field empty) , but I have to complete “Date/Time” and “Where” manualy… An extension of your project that would be nice to have would be that some selected text in the mail body (i.e. mutliselection of date – time – place) could be used to populate the corresponding field using your approach…
    Thanks for sharing all this!

Posting code or formulas in your comment? Use <code> tags!

  • <code lang="vb">Block of code goes here</code>
  • <code lang="vb" inline="true">Inline code goes here</code>
  • <code>Formula goes here</code>

Leave a Reply

Here's how to update your reports of company and nearly any web data: