Goal: Allow user to jump to a certain screen/field in Outlook 2003 to
quickly tag a contact record. Essentially I want to automate the following
sequence of keystrokes:
-Contacts
-All Fields tab
-All Contact Fields
-User Field 4 & enter a value of "HH"

I had imagined I'd just go into Macro and say "start recording keystrokes"
but that doesn't seem to exist. Correct?

Then I thought I could write something in VBA but I'm a VBA novice and I
don't quite know how to do what I want. Does anyone know/have any code that
would do this?

And if it can be done w/ VBA, can I trigger it from a hotkey combination or
a custom toolbar button?

Or if there's another/better way (other than VBA) of accomplishing what I
want, I'm all ears.

Thanks in advance for an advice!

-Rich

On Fri, 17 Feb 2006 13:37:43 -0500, Rich Roller wrote in
microsoft.public.outlook.program_vba:

Goal: Allow user to jump to a certain screen/field in Outlook 2003 to
quickly tag a contact record. Essentially I want to automate the following
sequence of keystrokes:
-Contacts
-All Fields tab
-All Contact Fields
-User Field 4 & enter a value of "HH"

I had imagined I'd just go into Macro and say "start recording keystrokes"
but that doesn't seem to exist. Correct?

Correct.

Then I thought I could write something in VBA but I'm a VBA novice and I
don't quite know how to do what I want. Does anyone know/have any code that
would do this?

ActiveInspector.CurrentItem.User4 = "HH"

And if it can be done w/ VBA, can I trigger it from a hotkey combination or
a custom toolbar button?
[snip]

Custom Toolbar Button is trivial: (View/Toolbar/Customize...). To add a
keyboard shortcut, see http://support.microsoft.com/?kbid=252427.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

AWESOME! Thank you Michael. I never thought it would be such a simple,
one-line procedure! -Rich

"Michael Bednarek" wrote in message
...
On Fri, 17 Feb 2006 13:37:43 -0500, Rich Roller wrote in
microsoft.public.outlook.program_vba:

Goal: Allow user to jump to a certain screen/field in Outlook 2003 to
quickly tag a contact record. Essentially I want to automate the
following
sequence of keystrokes:
-Contacts
-All Fields tab
-All Contact Fields
-User Field 4 & enter a value of "HH"

I had imagined I'd just go into Macro and say "start recording keystrokes"
but that doesn't seem to exist. Correct?

Correct.

Then I thought I could write something in VBA but I'm a VBA novice and I
don't quite know how to do what I want. Does anyone know/have any code
that
would do this?

ActiveInspector.CurrentItem.User4 = "HH"

And if it can be done w/ VBA, can I trigger it from a hotkey combination
or
a custom toolbar button?
[snip]

Custom Toolbar Button is trivial: (View/Toolbar/Customize...). To add a
keyboard shortcut, see http://support.microsoft.com/?kbid=252427.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

Yes custom toolbar buttons are easy... but do you know how to get the button
to display ONLY in the standard Contacts form but not in other
screens/forms? (After I added the button in Contacts, it's also showing up
in message views/forms)

Thanks again.

-Rich

"Michael Bednarek" wrote in message
...
On Fri, 17 Feb 2006 13:37:43 -0500, Rich Roller wrote in
microsoft.public.outlook.program_vba:


Custom Toolbar Button is trivial: (View/Toolbar/Customize...). To add a
keyboard shortcut, see http://support.microsoft.com/?kbid=252427.

On Sat, 18 Feb 2006 10:51:54 -0500, Rich Roller wrote in
microsoft.public.outlook.program_vba:

Yes custom toolbar buttons are easy... but do you know how to get the button
to display ONLY in the standard Contacts form but not in other
screens/forms? (After I added the button in Contacts, it's also showing up
in message views/forms)

I don't know. I suspect you would have to create and publish a form for
your contacts. There's another newsgroup which seems to deal with that:
microsoft.public.outlook.program_forms

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

I'll try to find the answer for that.

Thanks again for the simple but crucial VBA syntax you gave me!

-Rich

"Michael Bednarek" wrote in message
...
On Sat, 18 Feb 2006 10:51:54 -0500, Rich Roller wrote in
microsoft.public.outlook.program_vba:

Yes custom toolbar buttons are easy... but do you know how to get the
button
to display ONLY in the standard Contacts form but not in other
screens/forms? (After I added the button in Contacts, it's also showing
up
in message views/forms)

I don't know. I suspect you would have to create and publish a form for
your contacts. There's another newsgroup which seems to deal with that:
microsoft.public.outlook.program_forms

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

Can't you just test for Inspector.CurrentItem = olContact when you create
your button? Don't create the button if the test is True.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Rich Roller" wrote in message
...
I'll try to find the answer for that.

Thanks again for the simple but crucial VBA syntax you gave me!

-Rich

"Michael Bednarek" wrote in message
...
On Sat, 18 Feb 2006 10:51:54 -0500, Rich Roller wrote in
microsoft.public.outlook.program_vba:

Yes custom toolbar buttons are easy... but do you know how to get the
button
to display ONLY in the standard Contacts form but not in other
screens/forms? (After I added the button in Contacts, it's also showing
up
in message views/forms)

I don't know. I suspect you would have to create and publish a form for
your contacts. There's another newsgroup which seems to deal with that:
microsoft.public.outlook.program_forms

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

On Sun, 19 Feb 2006 17:38:25 -0500, "Ken Slovak - [MVP - Outlook]" wrote
in microsoft.public.outlook.program_vba:

Can't you just test for Inspector.CurrentItem = olContact when you create

(Shouldn't that be: Inspector.CurrentItem.Class = olContact ?)

your button? Don't create the button if the test is True.

That assumes the OP creates the button programmatically via an event
handler; I doubt that.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

Yes, sorry, Inspector.CurrentItem.Class = olContact.

The button should be created in an event handler for NewInspector, that's
the best way to do it.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Michael Bednarek" wrote in message
...
On Sun, 19 Feb 2006 17:38:25 -0500, "Ken Slovak - [MVP - Outlook]" wrote
in microsoft.public.outlook.program_vba:

Can't you just test for Inspector.CurrentItem = olContact when you create

(Shouldn't that be: Inspector.CurrentItem.Class = olContact ?)

your button? Don't create the button if the test is True.

That assumes the OP creates the button programmatically via an event
handler; I doubt that.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

Guys I'm not sure I totally follow.

I know how to create a button via the add/remove GUI (customize toolbar) but
how do I create a button conditionally? "in an event handler"? Or is it
possible to edit the properties of the button once it's created to make it
display conditionally (only if in Contacts form/view)?

Again, I'm novice programming so it'd have to be pretty easy, as was the
above tip for jumping to a specific field.

-Rich

"Ken Slovak - [MVP - Outlook]" wrote in message
...
Yes, sorry, Inspector.CurrentItem.Class = olContact.

The button should be created in an event handler for NewInspector, that's
the best way to do it.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Michael Bednarek" wrote in message
...
On Sun, 19 Feb 2006 17:38:25 -0500, "Ken Slovak - [MVP - Outlook]" wrote
in microsoft.public.outlook.program_vba:

Can't you just test for Inspector.CurrentItem = olContact when you create

(Shouldn't that be: Inspector.CurrentItem.Class = olContact ?)

your button? Don't create the button if the test is True.

That assumes the OP creates the button programmatically via an event
handler; I doubt that.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"