PC Review


Reply
Thread Tools Rate Thread

Can a script be writted to populate the subject field with other fields?

 
 
New Member
Join Date: May 2012
Posts: 1
 
      8th May 2012
I am in no way a dev or script writer, so a very specific answer will help. I created a custom template to schedule rooms in outlook. These rooms are run by 30 or so different groups. Under each group is an event that this group hosts. What is taking place now is the person entering them has to use a drop down (Just to get spelling correct for searches) and select the group. They then use a second drop down for the event.


Is it possible to create a script that can be ran upon closing, or sometime after selecting these values, that will populate the subject line? The person has to manually reenter this information so it is visible from the week view of the calendar. If this helps I think what I am looking for would automatically fill the subject field with a value of
[Ministry Name] * [Ministry Event]
I might be way off on my terminology so please forgive me if I am. Thanks
 
Reply With Quote
 
 
 
 
New Member
Join Date: May 2012
Posts: 1
 
      30th May 2012
Quote:
Originally Posted by DenzelTPA View Post
I am in no way a dev or script writer, so a very specific answer will help. I created a custom template to schedule rooms in outlook. These rooms are run by 30 or so different groups. Under each group is an event that this group hosts. What is taking place now is the person entering them has to use a drop down (Just to get spelling correct for searches) and select the group. They then use a second drop down for the event.


Is it possible to create a script that can be ran upon closing, or sometime after selecting these values, that will populate the subject line? The person has to manually reenter this information so it is visible from the week view of the calendar. If this helps I think what I am looking for would automatically fill the subject field with a value of
[Ministry Name] * [Ministry Event]
I might be way off on my terminology so please forgive me if I am. Thanks

No need for code, simply enter the fields you want concatenated as a formula. Open your subject field and put as the default value what you want to appear. Put text strings in "quotes", field names in [brackets] and join them all with the "&". e.g.:


"New Request - " & [Request Title] & " - " & [Requestor]


This will result in something similar to:

New Request - Create new location - Joe Blow

Make sure "calculate this formula automatically" is checked so that it will calculate as you make changes to the form. If you have "Calculate this formula when I compose a new form" the formula will see that all the fields are empty and so that will be your subject line, it won't update as you update the fields.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Incoming mail subject containing "p2" then the script should throw the 3rd string of the subject Jaxn77 Microsoft Outlook VBA Programming 0 6th Aug 2012 11:18 AM
Populate task field based on value of other field jparker Microsoft Outlook VBA Programming 9 12th Mar 2009 04:50 PM
Populate one field in a form based on value entered in other field Tracey Microsoft Access Forms 2 26th May 2005 01:18 PM
Script in Outlook XP: replace content of the "subject" field with content from"new field" sachama Microsoft Outlook VBA Programming 0 26th Dec 2003 05:58 PM
cant play re writted music mike g Windows XP Music 0 22nd Jul 2003 11:11 PM


Features
 

Advertising
 

Newsgroups
 


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