IT Freelancer – Java, J2EE, IBM WebSphere Portal, Lotus Notes/Domino
RSS icon Home icon
  • Lotus Notes’ [Send only] and [Send and File] buttons for Outlook 2003

    (4 votes) 1 Star2 Stars3 Stars4 Stars5 Stars
    Loading ... Loading ...
    Posted on 19 February 2009 19 comments

    You can say what you want about Lotus Notes, if you have used it for a while and switched e.g. to Outlook, you’ll find yourself missing one or the other nifty Notes function.

    Already two of my customers “forced” me to use MS Outlook 2003 and since this isn’t likely to change in the near future, I implemented two of these handy Notes functions for Outlook 2003:

    1. The button [Send only] sends e-mails without storing a copy of it in the local mailbox.
    2. The button [Send and File...] prompts you for the folder where to store the e-mail being send.

    Installation:

    1. Download the Visual Basic module in the favored language.
      Download: Send Mail Macros for MS Outlook 2003 (EN)  Send Mail Macros for MS Outlook 2003 (EN) (4.9 KiB, 1,748 hits)

      Download: Send Mail Macros for MS Outlook 2003 (DE)  Send Mail Macros for MS Outlook 2003 (DE) (5.1 KiB, 812 hits)

    2. In Outlook open the Visual Basic editor.
      open VBE from within outlook
    3. Import the Visual Basic module.
      Import the VBE module Select the VBE module The VBE module was imported.
    4. Save the project.
      Save the VBE project
    5. Install the buttons in the toolbar.
      Open the Macros dialog Installing the button [Send and File...] Button [Send and File...] installed Installing the button [Send only] Button [Send only] installed
    6. When composing a new e-mail the additional buttons should appear in the toolbar.
      New buttons in the toolbar
    7. When clicking “Send and File…” the folder dialog is displayed before the e-mail is send.
      Selecting the target folder
     

    19 responses to “Lotus Notes’ [Send only] and [Send and File] buttons for Outlook 2003”

    1. Marcus Jacob

      Hallo Herr Thomschke,
      habe o.a. Makros unter Outlook 2007 ausprobiert. Funktioniert prinzipiell auch. Schade ist nur, das die Schaltflächen aufgrund der Ribbons nicht so schön angeordnet sind wie bei OL2003. Habe Sie vielleicht schon Portierungen auf OL2007?

      Mit freundlichen Grüssen
      Marcus Jacob

    2. JohnBlack

      Dear Sebastian, does this also work for Outlook 2007 ?

      ps: I’m also experiencing another annoyance from the swith from Lotus to outlook. When working with multiple mail boxes, Lotus notes automatically switched the “from field” to display the fact that JohnBlack sent the mail from “New mailbox”.

      So what i want is that when i send an email from another mailbox (not my own), Outlook automatically changes the from attribute to JohnBlack on behalf of New mailbox.

      Thanks in advance,

      JB

    3. Hi John,
      I do not have access to Outlook 2007 so I cannot say if it works there or not.

      Regards,
      Seb

    4. Works great and thanks a lot. You should note that it only works if you have Outlook as your default email editor. If Word is set as the email editor it will not work. Other wise a bunch of people at my office thank you.

    5. JohnBlack

      Dear Sebastian, i’ve installed your macro in Outlook 2007 and it works but not exactly how it worked in lotus notes. If you for exmaple would choose “send and file” it would send the email and copy it to a folder of your choosing. But it would also place the email (like any other mail you send) in the “sent” folder. Could you add this option so it will also put send emails in the actual addition “send items” folder

    6. Hi John,
      I think the problem is that the “sent” folder is a folder in Outlook whereas it is a view in Lotus Notes. So if the button should also make the e-mail available in the sent folder it would have to make a copy of the e-mail and place it there. Instead I’d recommend you to create a custom view ( http://outlook-tips.net/howto/custom_views.htm ) showing all e-mails sent by you.

      Regards,
      Seb

    7. do you have a updated version for outlook 2007.
      Thanks a lot
      Lorance

    8. Hi Lorance,

      my customers did not yet migrate to Outlook 2007. Thus I didn’t have an opportunity to test the code on the new version.

      Regards,

      Seb

    9. Dear Sebastian,

      I am using this macro and it’s very helpful for me. But I am missing one feature.
      When I click on one of these buttons the the spell check is missing even it it is enabled in the options of Outlook.
      How can this be turned on?

      Regards
      Dirk

    10. Hi Sebastian,

      Thanks for this piece of work! Works fine in Outlook 2007, just that Outlook put the buttons under the Add-ons Ribbon, so you need 2 clicks to get to it when sending. No big deal – it’s *far* superior to dragging your message from Sent Items to the folder of choice.

      I might look into associating a keyboard shortcut with it at some point.

      Thanks a million!
      Sandra

    11. Tomas Wolf

      I followed the above post but cant figure out how to install the buttons in the toolbar. Feel a little foolish sorry

    12. At which step do you get confused?

    13. Thanks for the Macros, i just downloaded the german .bas and installed it successfully.

      The “Senden und ablegen” Button works, but on the “Nur Senden” Button prompts for a place to store the file like the “Senden und ablegen” Button.

      I am using Outlook 2003 SP3 german.

    14. Problem solved, my mistake. If you follow the detailed instructions then it works perfectly.
      Thanks once more.

    15. Awesome! Works nicely in Outlook 2007.
      To get it on the Quick Access Toolbar for a one click solution, Open Visual Basic Editor in Outlook and create a macro immediately under Sebastian’s existing code:
      ~~~~~~~~~~~~~
      Public Sub SaveAndFile_Run()

      SendandFile

      End Sub
      ~~~~~~~~~~~~~~~

      Then customize the quick access toolbar, choose commands from Macros and add the SendAndFile_run macro. Modify to an icon and text of your choice and it’s all good!

      Thanks Sebastian for a really useful piece of code!

    16. I haven’t installed this yet, but likely will. I find it hard to believe that every mail system doesn’t have this. It is basic: you want your sent mail in the folder with the received mail on that subject. In my case it is mostly to keep communication with customers together. Problem is that I REALLY don’t want to keep using Outlook, even with this new function. (Using Lotus Notes client stand alone right now, but the newer releases seem buggy to me).
      Thanks!

    17. Thanks alot!!! Works great!
      I missed that feature sadly since my company switched to Outlook!

    18. Thanks. This is great and works in Outlook 2007.

    19. Thanks! You saved my life with this elegant code! I had an add-in for Outlook that did the same thing, and loved it. Somehow, I had failed to backup the original add-in installer, and when I migrated to a new computer I lost it. You saved me hours of coding–I’m not much of a VB person.

      Wish you had included some code to just file an email from the inbox by clicking a toolbar button, but I guess you can’t have everything. ;-)

      Thanks again! M

    Leave a reply