Now you can Twitter from Outlook too
February 12, 2009 • JP • 2 Comments • Rate This Article
• Links to this article
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 «
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
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. Keep Reading »
Previous Post: Random sample data generator add-in update
Next Post: Put images in comments
JP:
I've just downloaded this add-in and it works (almost) perfect. The only problem I have is when I use accents. The API (or the add-in, I don't know) kind of truncates the word where the accent appears. For example:
I twitted this:
"Test para saber por qué la API cortó inútilmente mis párrafos."
Twitter showed:
"Test para saber por quéa API cortóúente mis páafos."
I wonder if you could fix it.
Regards.
My guess is that you need to use an array of accented characters, then check the passed string for them and replace them with their Chr equivalents. For example "é" is Chr(233).