Thanks to the Tracks contributors for a great product.

I use Outlook at work and wanted a convenient way of turning mail messages into Tracks todo items. After a minor struggle with VBA, a workable solution exists.

This macro adds a new item to the right-click context menu which allows Tracks todos to be created directly from the Outlook application. It can currently set the Todo context and project, but does not deal with tags, ‘due by’ and ‘show from’.

I don’t think end-user developed Outlook macros were meant to be shipped around, but installation is not too painful in the end. The procedure is documented in the wiki, at:

http://www.rousette.org.uk/projects/wiki/Outlook-Integration/

All feedback appreciated.

Greg

Installation went well, but Outlook 2007 nags me at every start. Anyway to sign the code?

I’m not sure why, but the form never shows. When I select Add to tracks, it just shows an empty email…

Hi Reinier

Thanks for your feedback.

I have not tested Outlook 2007 - I will install and attempt to isolate the issue.

I am not sure if Outlook VBA macros can be signed - the functionality may need to be built into a compiled application instead.

Greg.

Ok, the nag screen is, for me, a blocker Currently I forward email to tracks, but this right-click option is very tempting, especially because you can change the todo before it is sent to tracks.

Hi Reinier

I have added a section to the wiki page which details how to self-sign the VBA code and remove the macro security warning on startup.

I can’t replicate your other issue - I have installed a clean Windows XP (SP2)/Office 2007 machine and configured the macro there. The Add Todo window opens as it should. I’ll send you a private message with some additional debugging steps to try to isolate the problem.

Regards,
Greg.

Thank! I’ll try it again soon using your instructions.

The script install succeeded and I did get rid of the warning when starting up.
So far so good.

But it has problems with my personal site (or externally hosted ones)
using https as a protocol and proxy authorization.

I Googled and added the following (you need some extra variables!):

Which seems to solve the issue of proxy authorization.

But the certificate on the other site causes problems so the script fails.

Any ideas how to solve this?

I’ve tried your latest code. Unfortunately it doesn’t work with latest tracks. I’ve modified your code a bit. I’m now able to send a todo to tracks, only the retrieval of contexts and projects is not working yet. I hope to work on it tomorrow.

I’ve also tried your latest code and did create the same fix for the proxy that I do need. Unfortunately it doesn’t work correctely with latest tracks only the retrieval of contexts.txt and rss and projects.txt/rss is working yet for me. The .xml file is rejected on user password. I like this plug-in for outlook.
Can I expect a change in tracks to support the user:pass correct or do I have to update the outlook plugin to support txt files?
I expect than that I run in to the same problem when sending the update to the API of tracks.

I have some working code which uses the current REST API, so there are no changes in Tracks necessary

Can you upload the updated code so I can also try?

I’ve added my code to github here: http://github.com/lrbalt/outlookemailtotracks/tree/master

Greg, I assumed that you’re ok with this. If not, I’ll remove it right away.

Thanks,
I do try to load the code in Outlook VB as I did before (also mentioned in the http://www.rousette.org.uk/projects/wiki/Outlook-Integration/ ) but now I get the next error on loading the .frm file:
“Too many line continuatiuons” and impossible to continue.
I did download the files using “save link as..” on both TodoForm10.frm and frx.
It looks the same problem as mentioned in http://www.dailydoseofexcel.com/archives/2005/04/18/line-continuation-limit/

hm, I think it has to do with LF (unix) versus CRLF (DOS). Git tries to be intelligent and convert between them. I’ll see if I can change the line endings

If you can create a zip/tar file with the files than the problem is also fixed I think, if Git is to “intelligent”

Uhm, did you use save link as? The resulting file will then be a HTML file, but not a .frm.

You can use the download button of github to get a .zip of the files