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

    (5 votes) 1 Star2 Stars3 Stars4 Stars5 Stars
    Loading...
    Posted on 19 February 2009 Sebastian Thomschke*/?> 24 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.

        Send Mail Macros for MS Outlook 2003 (EN) (4.9 KiB, 4,187 hits)

        Send Mail Macros for MS Outlook 2003 (DE) (5.1 KiB, 2,492 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
  • Excel – VBA Timer Example v1.0.1

    (9 votes) 1 Star2 Stars3 Stars4 Stars5 Stars
    Loading...
    Posted on 6 April 2002 Sebastian Thomschke*/?> 17 comments

    A friend of mine asked me about how to let excel periodically update some worksheets.
    So the first thing I did was searching the web for a solution in Visual Basic for Applications. But the only one I found was to use a 3rd party ActiveX timer control which you have to place onto a userform. Then I found the VBA command “Application.onTime” and had an idea.

    Here is my solution only utilizing the VBA onTime command. No need for ActiveX control or any other 3rd party module.

    Read the rest of this entry »