Now you can Twitter from Outlook too
February 12, 2009 @ 9:59 PM by JP • 1 views • No Comments »
I ported the Post To Twitter Excel add-in over to Outlook, so you can use it in Outlook as well.
All I had to do was export the Excel modules and import them into Outlook's VBIDE, with no modification whatsoever. 
Ok, I did make one slight change. I moved the code that enables the tweet button to the Change event, instead of the AfterUpdate event. But I was planning to do that with the Excel version of the code anyway.
Note that this is a low-fi version of other tools such as OutTwit, which are probably written in VSTO and actually integrate with Outlook.
» Download Twitter From Outlook «
After downloading the file, unzip and import both .bas files and the .frm file into your Outlook VBIDE as follows.
- Start Microsoft Outlook
- Press Alt-F11 to open the VBIDE
- Press Ctrl-M and browse to the folder where you unzipped the archive.
- Select the modStart.bas file and click Open
- Press Ctrl-M again and open the modTweet.bas file.
- Press Ctrl-M again and open the frmTwitter.frm file. (leave the .frx file alone)
- Press Alt-Q to close the VBIDE.
Press Alt-F8 and run the AddButton macro to create a toolbar button with the macro that opens the form attached to it. You can delete the AddButton macro after that, if you like, and you can also delete the files from the zip archive you opened. Now on the Advanced toolbar, you should see a new button: Post To Twitter. Click it and you'll get the exact same screen as in Excel.
» Download Twitter From Outlook «
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA (or subscribe via email). Keep Reading »
Previous Post: New developments
Next Post: Put images in comments
Speak Your Mind
Tell us what you're thinking...and oh, if you want a pic to show with your comment, go get a gravatar!
Certain comments (including first-time comments) are subject to moderation and will not appear immediately. Please view the Comment Policy for more information. To post VBA code in your comment, use tags like this: [cc lang='vb']Code goes here[/cc].