I Need A Macro

Hi

I use Windows 2000 with Outlook 2000. I would like to have a macro that
allows me to:

1. Go to File
2. Open
3. Other User's Folder
4. Select Name (then pick the name I want eg: John Smith, Conference Room etc)
5. Select Calendar from the "Folder" drop down box
6. Select "OK"

Is this possible?

Any help would be much appreciated, thanks


John Calder

Not like that it's not. You could access the File, Open menu but from there
you would be working with the menu itself, which can't be controlled. To do
exactly what you want would require creating a form (UserForm in Outlook
VBA) with the list of folders you want to open and then when a selection was
made using the NameSpace.GetSharedDefaultFolder method with the selection as
an Outlook Recipient item to open the folder.

--
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


"John Calder" <John Calder@discussions.microsoft.com> wrote in message
news:EACB9AE9-13EA-4E39-9D4E-90F9599F5F58@microsoft.com...
> Hi
>
> I use Windows 2000 with Outlook 2000. I would like to have a macro that
> allows me to:
>
> 1. Go to File
> 2. Open
> 3. Other User's Folder
> 4. Select Name (then pick the name I want eg: John Smith, Conference Room
> etc)
> 5. Select Calendar from the "Folder" drop down box
> 6. Select "OK"
>
> Is this possible?
>
> Any help would be much appreciated, thanks
>
>
> John Calder
>

It would be pretty easy to do actually. Just go through
the exact process of opening the folder without using
your mouse, only keyboard commands. During the process,
record every keystroke you make, and once you have it all
written down write a VBScript and use the "sendkeys"
command to send the keystrokes. Remember to sleep the
program a little if some things take a little while to
load after the previous keystroke (ie: a window takes 3
seconds to pop up, used wscript.sleep 3000)

Tim
>-----Original Message-----
>Hi
>
>I use Windows 2000 with Outlook 2000. I would like to
have a macro that
>allows me to:
>
>1. Go to File
>2. Open
>3. Other User's Folder
>4. Select Name (then pick the name I want eg: John
Smith, Conference Room etc)
>5. Select Calendar from the "Folder" drop down box
>6. Select "OK"
>
>Is this possible?
>
>Any help would be much appreciated, thanks
>
>
>John Calder
>
>.
>

Outlook has no macro recorder so that won't work at all.

Once you access a menu item using code you have no control over the dialog
that menu item shows or any properties in that dialog.

--
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


"Tim" <tcastantine@jlack.com> wrote in message
news:07ce01c51b7b$dc0f8860$a501280a@phx.gbl...
> It would be pretty easy to do actually. Just go through
> the exact process of opening the folder without using
> your mouse, only keyboard commands. During the process,
> record every keystroke you make, and once you have it all
> written down write a VBScript and use the "sendkeys"
> command to send the keystrokes. Remember to sleep the
> program a little if some things take a little while to
> load after the previous keystroke (ie: a window takes 3
> seconds to pop up, used wscript.sleep 3000)
>
> Tim