[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Microsoft, Outlook, 2003 Outlook Appointment Subject field

Posted on 2008-01-31
8
Medium Priority
?
833 Views
Last Modified: 2010-04-21
Need to create two Meeting Requests with customized fields.  I can make a "message look good, but the Date/calendar connections are lost..  When making an custom appointment on page 2, I cannot get the subject to appear on first page subject content.  Is there anyway to have an Appointment's Subject line on original appointment page to have a customized value based on three user defined combined fields ?  (i.e. value:   [Company]  ([Ticker])   $[Market Cap] millions) should show in Subject line.

0
Comment
Question by:webuser1211
  • 4
  • 4
8 Comments
 
LVL 76

Expert Comment

by:David Lee
ID: 20795859
Hi, webuser1211.

Yes, you can set the subject line of an appointment.  I don't understand the situation though.  What do you mean when you say "the Date/calendar connections are lost"?  How are you trying to set the subject?
0
 

Author Comment

by:webuser1211
ID: 20797882
Sorry to be confusing!  Bottom-line - What I need is a Meeting Request/Appointment form where User Defined Fields (UDFs) will appear on the first (not a second) page in addition to all fields that are already there.  Some of the USFs would autopopulate the Subject line - all USFs would be required fields before it could be sent.  The Subject needs to include concatenated 3 UDFs.  When the user types:
1.  the Company name in a USF field it will always appear as the first item in the subject line.
2.  the Ticker name in a USF field it will always appear as the second item in the subject line surrounded by parentheses.
3.  the Market Caps name in a USF field it will always appear as the last item in the subject line preceded by $ and followed by "in millions".

Re: "the Date/calendar connections are lost" I could not find a way if i created the form based on a "Message" to make it show up on an invitee's or my calendar if they accepted.

I hope this helps?
if I attach and OFT or ICS does everyone see it? or only you?

0
 
LVL 76

Expert Comment

by:David Lee
ID: 20802660
Unfortunately what you've described isn't possible.  You cannot modify the first page of a meeting request/appointment form.  However, you can modify all other pages and/or add pages, and you can set the value of controls that are on the first page.

Correct.  A form based on anything other than an appointment/meeting request will not update the calendar.

Anything you attach to this question will be visible to anyone who looks at the question.
0
Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

 

Author Comment

by:webuser1211
ID: 20802814
How do I access the properties of the subject line (and other fields) on the first page?  I have tried adding " [Company]  ([Ticker])   $[Market Cap] millions" to the value of the Subject field on Properties Tab.  When I run the form and fill in the [Company] field etc. the subject values does not show the company name, etc.

Or do I have to delete/or hide the 1st (default) page and re-create it on the 2nd page so I can access the properties
0
 
LVL 76

Accepted Solution

by:
David Lee earned 2000 total points
ID: 20809613
No, you don't need to delete or hide the first page.  You just need to use some code like that below to populate the Subject.  Keep in mind that each control you add to the form has to be bound to a user property in the Outlook item.  The solution then is to trap the CustomPropertyChange event so that the subject is calculated each time one of your custom fields is filled in.  Something like this:

Sub Item_CustomPropertyChange(ByVal Name)
    Dim varVal1, varVal2
    'Change Prop1 and Prop2 on the following two lines to the names of your properties
    varVal1 = Item.UserProperties("Prop1").Value
    varVal2 = Item.UserProperties("Prop2").Value
    Item.ItemProperties.Item("Subject").Value = varVal1 & " " & varVal2
End Sub 

Open in new window

0
 

Author Closing Comment

by:webuser1211
ID: 31623455
I have a lot to learn!!!!!!!!!   Do you have a book or a website that you recommend that deals with Outlook Forms?  
THANK YOU FOR ALL YOUR HELP!!!!!!
0
 
LVL 76

Expert Comment

by:David Lee
ID: 20854231
You're welcome.  Glad I could help.

Yes, I stongly recommend Sue Mosher's book titled "Microsoft Outlook Programming" by Digital Press (ISBN: 1-55558-286-9).  I also recommend her website Outlookcode.com (http://www.outlookcode.com).  
0
 

Author Comment

by:webuser1211
ID: 20854461
Thank You Again!  
0

Featured Post

Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.
As a matter of fact, Outlook OST files are of much importance in relation to Exchange mailbox. OST files are independent as they are simply copy of data of a user’s mailbox on Exchange Server. Though, if the server’s status is changed or it is dama…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question