Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Forms (http://www.outlookbanter.com/outlook-using-forms/)
-   -   calendar form (http://www.outlookbanter.com/outlook-using-forms/40804-calendar-form.html)

Patrick February 14th 07 02:47 PM

calendar form
 
Hi,
is it possible to create a custom calendar form which is actively linked to
a contact?

I.e. i have a department contact and calendar in a public exchange folder.
With the custom calendar form i wish to schedule an appointment with a
client who is selected from the department contacts.
After having selected this client, on the custom form, i want to see the
contacts company name and address (and probably some more stuff) and more
importantly the "notes" field (from the contact), as i use this field to add
meeting notes.

In addition i would like to introduce a custom drop down which i could use
to select the status of the meeting (i.e. requested, accepted, declined).

Any sugestions please?

Thanks
Patrick



David Tongeman February 17th 07 01:22 AM

calendar form
 
Patrick, you will need to use VBA behind your form (which you probably knew).

Selecting the contact to link top can either be done by populating a
dropdown box with a list of clients, or by selecting the contact from the
folder. You might be better to add a button to the contact form to (add
linked appointment) which would negate the need to find the contact.

Once you have the contact and the new appointment item you can add the
item.companyname, item.businessaddress, item.body fields to the appointment
item body.

How is your VBA?

Sue Mosher [MVP-Outlook] February 19th 07 03:42 PM

calendar form
 
Actually, VBScript, not VBA is the language that custom forms use.

--
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

"David Tongeman" wrote in message ...
Patrick, you will need to use VBA behind your form (which you probably knew).

Selecting the contact to link top can either be done by populating a
dropdown box with a list of clients, or by selecting the contact from the
folder. You might be better to add a button to the contact form to (add
linked appointment) which would negate the need to find the contact.

Once you have the contact and the new appointment item you can add the
item.companyname, item.businessaddress, item.body fields to the appointment
item body.

How is your VBA?



All times are GMT +1. The time now is 07:53 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com