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 / November 2004

Tip: Looking for answers? Try searching our database.

Exporting information from an Appointment in Outlook

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sam - 11 Nov 2004 21:28 GMT
I have a small pice of code that generates an email messages to a user when
ever someone enters an appointment in their calendar. Currently, the email
that is generated tells them a new appointment has been added to their
calendar. How can I export out information from the following fields:

Subject
Location
Start Time
End Time

to make the email sent out more meaningful? I would like to send out an
email that says something like this:

A new appointment has been added to your calendar.
Subject: HR Meeting
Location: Conference Room 1A
Start Time: 11/15/04 11:00 am
End TIme:  11/15/04 11:30 am

I know how to do this with a custom form, but can't figure out how to do it
for a standard form - not sure what labels to query. In a custom form, if I
had a field called DT, I would query its value and generate an email with
that value:

MyItem.Body = "Subject: " + chr(13) + userproperties("dt").value

Just not sure what to query in this case.

Thanks.

S
Sue Mosher [MVP-Outlook] - 11 Nov 2004 22:15 GMT
You need to get the properties from the specific appointment -- same syntax
as MyItem.Body. If your code an event handler for MAPIFolder.Items.ItemAdd,
that appointment is the one passed as an Item argument for the event
handler.

Signature

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

>I have a small pice of code that generates an email messages to a user when
> ever someone enters an appointment in their calendar. Currently, the email
[quoted text clipped - 29 lines]
>
> S
 
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



©2009 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.