Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming VBA / February 2005

Tip: Looking for answers? Try searching our database.

I Need A Macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Calder - 24 Feb 2005 21:29 GMT
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
Ken Slovak - [MVP - Outlook] - 25 Feb 2005 14:02 GMT
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.

Signature

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

> Hi
>
[quoted text clipped - 14 lines]
>
> John Calder
Tim - 25 Feb 2005 20:52 GMT
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
[quoted text clipped - 16 lines]
>
>.
Ken Slovak - [MVP - Outlook] - 28 Feb 2005 15:01 GMT
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.

Signature

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

> It would be pretty easy to do actually.  Just go through
> the exact process of opening the folder without using
[quoted text clipped - 7 lines]
>
> Tim
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.