Best way to tweak Outlook 2007 with VBA/VBS?

[Ichinisan]

Should this go here in the Programming sub-forum? ...or should it go in Software for Windows?


As a favor for someone, I want to make a custom Save-As button that saves in the MSG format by default instead of saving as HTML.

https://msdn.microsoft.com/en-us/library/aa210279(v=office.11).aspx

I don't think I've ever done anything with VBA, but I've worked a little bit with VB6 a long, long time ago.

What's the first step? I could take some of the example code from that article and change the type from from "olTXT" to "olMSG" -- do I save that as a .VBA file or a .VBS file? How do I then register that as a command button or menu item in Outlook 2007?

Gonna start poking around and I'll check back here shortly...

 

[KB]

Why bother? All you have to do is drag the email from the explorer pane onto the desktop and its creates a file in msg format. Second my Outlook 2010 defaults to msg format when I do "Save As".

If you still want to do it, I would do it as a VSTO Add-In https://msdn.microsoft.com/en-us/library/cc668191.aspx

 

[Ichinisan]

Why bother? All you have to do is drag the email from the explorer pane onto the desktop and its creates a file in msg format. Second my Outlook 2010 defaults to msg format when I do "Save As".

The guy I'm helping is visually impaired. We already figured out the drag-drop procedure and determined that it is difficult for him.

(aerosnap left, open Explorer, aerosnap right, browse to destination, locate message in Outlook, find an empty spot in the destination folder, drag-and-drop)

He used Windows XP + Outlook XP (2002) until ~1 week ago and the transition to Windows 7 + Outlook 2007 has been difficult for him.

If you still want to do it, I would do it as a VSTO Add-In https://msdn.microsoft.com/en-us/library/cc668191.aspx

Thanks. I'll look into that.

 

[Ken g6]

As someone not familiar with VBA/VBS, the first thing that comes to mind for me is AutoHotKey.

 

[Tweak155]

This sounds easy to do in VBA. Using VSTO sounds like overkill for something so small.