View Single Post
  #5  
Old March 20th 07, 10:11 PM posted to microsoft.public.outlook.program_vba
Steve
external usenet poster
 
Posts: 20
Default Insert subject on new message

Thank you. This is something I couldn't find direction on in my search of
the web. My company won't shell out for a book on programming Outlook to
ease a couple of tasks.

VBA in Outlook still looks very foreign, despite my experience in other MS
products. Vastly different from swtiches between Access, Excel and Word. I
have a strong feeling a lot of research is required to solve my problem but,
if I can work with values chosen in forms in Excel, surely the general
principals can't be that different.



"Michael Bauer [MVP - Outlook]" wrote in message
...


This is how to handle the events:

Private WithEvents m_Inspectors As Outlook.Inspectors
Private WithEvents m_Inspector As Outlook.Inspector

Private Sub Application_Startup()
Set m_Inspectors = Application.Inspectors
End Sub

Private Sub m_Inspectors_NewInspector(ByVal Inspector As
Outlook.Inspector)
Set m_Inspector = Inspector
End Sub

Private Sub m_Inspector_Activate()
' ...
End Sub


--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Quick-Cats - The most effective way to assign Outlook categories:
http://www.shareit.com/product.html?...4&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)

Am Thu, 15 Mar 2007 18:15:13 +1100 schrieb Steve:

I've written VBA in Access, Excel and Word but never touched Outlook.
NewInspector is a new term to me. Can someone direct me where I can

research
how to use this to handle what I need in a new message.

"Michael Bauer [MVP - Outlook]" wrote in message
. ..


You can create a UserForm with a combobox on it. Track the NewInspector
event and then the new inspector's Activate event. In that show the
UserForm.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
The most effective way to assign Outlook categories:
http://www.shareit.com/product.html?...4&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)

Am Thu, 15 Mar 2007 10:22:27 +1100 schrieb Steve:

Hello

My company introduced a new mandatory security rating to be inserted

into
the subject of all emails. Is there a way to give users a drop-list to
select the appropriate rating whenever a new message is created?

Versions - 2000 and 2003 (soon to be upgraded).

Steve



Ads