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 / Calendaring / September 2005

Tip: Looking for answers? Try searching our database.

How do I delete an appointment using vbscript

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ldreifke - 13 Sep 2005 22:34 GMT
I've created a script that adds an appointment but now need the ability to
delete that appointment if the situation changes?  How do I do that?
Ldreifke - 13 Sep 2005 22:48 GMT
I suppose I should add the script that I used to create the item in the first
place.  

Sub test()

Set obj = CreateObject("outlook.application")
Set app = obj.CreateItem(1) ' means outlook appointment item

app.Duration = getfield("Duration","value")
app.Location = Eworkgetfield("Location","value")
app.MeetingStatus = 1
app.Body = Eworkgetfield("Comments","value")

a = eworkGetField("DueDate","Value")
'a=(getfield ("DateTime",""))
b=mid(a,1,4)+ "/"+mid(a,6,2)+"/"+mid(a,9,2)+ " "+ mid(a,12,2)+":" +
mid(a,15,2)
app.Start = cdate(b)
'msgbox app.Start

'app.Recipients.Add(cstr(getfield("recipients","value")))
app.RequiredAttendees =cstr(getfield("OutlookList","value"))

app.Subject = Eworkgetfield("mDescription","value")
app.send
app.save

Set app = Nothing
Set obj = Nothing

End Sub

> I've created a script that adds an appointment but now need the ability to
> delete that appointment if the situation changes?  How do I do that?
Sue Mosher [MVP-Outlook] - 13 Sep 2005 23:09 GMT
The real issue is: What information will let you "find" that particular appointment again? That's a question only you can answer in the context of your specific application.

FYI, there is a newsgroup specifically for general Outlook programming issues "down the hall" at microsoft.public.outlook.program_vba or, via web interface, at http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public
.outlook.program_vba


Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx

>I suppose I should add the script that I used to create the item in the first
> place.  
[quoted text clipped - 30 lines]
>> I've created a script that adds an appointment but now need the ability to
>> delete that appointment if the situation changes?  How do I do that?
Ldreifke - 15 Sep 2005 19:10 GMT
You're exactly right.  I can pass variables, but what variables to pass?  

I appreciate the link.  I'll head on down that way.

Thanks.

> The real issue is: What information will let you "find" that particular appointment again? That's a question only you can answer in the context of your specific application.
>
[quoted text clipped - 34 lines]
> >> I've created a script that adds an appointment but now need the ability to
> >> delete that appointment if the situation changes?  How do I do that?
Sue Mosher [MVP-Outlook] - 15 Sep 2005 19:46 GMT
No fair: That's the question I was asking. <g> You're the only one at this point who knows enough about your application to decide. If you don't expect the appointment to ever move, you can get the item's EntryID property after you save it and store that, then use it with the Namespace.GetItemFromID method to return that appointment.

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx

> You're exactly right.  I can pass variables, but what variables to pass?  
>
[quoted text clipped - 38 lines]
>> >> I've created a script that adds an appointment but now need the ability to
>> >> delete that appointment if the situation changes?  How do I do that?

Rate this thread:






 
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.