Lotus Notes’ [Send only] and [Send and File] buttons for Outlook 2003

(4 votes)

 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.
     Send Mail Macros for MS Outlook 2003 (EN) (4.9 KiB, 1,748 hits)

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

2. In Outlook open the Visual Basic editor.
   
3. Import the Visual Basic module.
   
4. Save the project.
   
5. Install the buttons in the toolbar.
   
6. When composing a new e-mail the additional buttons should appear in the toolbar.
   
7. When clicking “Send and File…” the folder dialog is displayed before the e-mail is send.
   

Excel – VBA Timer Example v1.00

(6 votes)

 Loading ...

Posted on 6 April 2002 14 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 »