new message - menubar/makros/vba

  • Thread starter Thread starter Peter Ramsebner
  • Start date Start date
P

Peter Ramsebner

Hi all,

i want to log outgoing messages in a sql server database.
The principal idea is:
1) write a new mail message
2) instead of using the send button, the user have to click a user defined
button wich:
- saves the message (to generate an EntryID)
- send the message
- create a record in my sql server database

The Problem is that new messages doesn't have a customer menu bar and it is
not possible to run vba code or makros.
-> How can i solve this problem?

Any help would be greatly appreciated

Peter
 
Hi Eric,

first, thanks for the expample code 'Sub AddInspectorMenu()'.
If you can't run macros due to security settings, you can create a custom
IPM.Note mail form with VBScript to trap the Send event and put in your db
insert code.
Click to expand...

Maybe you have misunderstood my problem?

I have created and executed your 'Sub AddInspectorMenu()' - and it works.
That means, when i open a message there is a new menuitem.
But not in new message items! Additionaly under this condition it's
impossible to run makros manually.

to remember: I need a menuitem in new messages to create a log entry in a
'sql server' database.

Is this so hard to realize?


thanks, Peter
 
Hi Eric,

now it works, but i don't know why not befor?
If this code needs to run on more than one PC, your best approach is to
develop this as a COM Add-In that will add the menus if they don't exist
every time Outlook starts. Then you can declare the menu/button controls
With Events, and call other procedures (such as your database update code)
from the Click event.
Click to expand...

A COM Add-In needs to be a executable file?

Finally i don't need the menubar. I have found the send event, so the user
does not need to press a further button (only the normal send button).

To install the code on all workstations my idea was to distribute the
VbaProject.OTM file.
Are there better methods?


thanks, Peter
 
Back
Top