Thank you for the tips. I've been specialising in Excel for about four years
after breaking away from many years of Access programming but it might be
time to see what can be done to make Outlook work for us instead of being
"the email program".
Steve

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


The main difference is, Excel and Word are file related. In Outlook
there're
Stores and Folders, Explorers for the folder view and Inspectors for open
items.

You can learn a lot by using the object browser (f2), which shows the
object
model, the objects' properties, procedures and events. Except for
constants,
you can select each item and press f1 for help, which often comes with VBA
samples, too.

--
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 Wed, 21 Mar 2007 08:11:29 +1100 schrieb Steve:

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