Macro to delete Appointments and Import an update

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

Guest

I have a routine of about 15 mouse clicks that I perform almost daily and would like to automate
Business Need
Share one individual's appointment book with others

Is the following possible? (I'm running Outlook 2002 but would be willing to upgrade

Calendar
Select All appointment
Delet

File impor
From another schedule or program fil
Schedule+ 7.
file path ___________

I know that Excel or Project's macro recorder would make this request a snap.
 
I've dug deeper into the VBA reference for Outlook and have pretty much concluded that it doesn't support such a procedure programmatically.

Could a long series of "sendkey" statements be applied as an alternative?
Thanks to anyone who can direct me.
 
I've dug deeper in the VBA reference and have pretty much concluded that Outlook VBA doesn't support the commands to create such a procedure.

Question: As an alternative could a series of SendKey statements work in my case?

Thanks to anyone who can direct me
 
After digging deeper into the VBA reference, I've pretty much concluded that Outlook VBA doesn't support those commands.

As an alternative, could a series of Sendkey statements achieve the same thing?

Any assistance directing me down the proper path would be greatly appreciated.
 
Like all the Office programs, Outlook has a rich object model for this kind
of automation. See http://www.outlookcode.com/d/customimport.htm for import
examples.

If you're new to Outlook VBA macros, these web pages should help you get
started:

http://www.winnetmag.com/Articles/Index.cfm?ArticleID=21522&pg=1
http://www.outlookcode.com/d/vb.htm

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



ralph said:
I've dug deeper into the VBA reference for Outlook and have pretty much
Click to expand...
concluded that it doesn't support such a procedure programmatically.
 
Back
Top