I Need A Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
Back
Top