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

Discussion in 'Microsoft Outlook Form Programming' started by DenzelTPA, May 8, 2012.

  1. DenzelTPA

    DenzelTPA

    Joined:
    May 8, 2012
    Messages:
    1
    Likes Received:
    0
    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
     
    DenzelTPA, May 8, 2012
    #1
    1. Advertisements

  2. DenzelTPA

    tnwalker

    Joined:
    May 30, 2012
    Messages:
    1
    Likes Received:
    0

    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.
     
    tnwalker, May 30, 2012
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. soundneedle@hotmail.com

    Populate list box using "Subject" field

    soundneedle@hotmail.com, May 20, 2005, in forum: Microsoft Outlook Form Programming
    Replies:
    3
    Views:
    501
    Sue Mosher [MVP-Outlook]
    May 20, 2005
  2. Dave C.

    Populate Company field from Contact field in custom task form

    Dave C., Jan 2, 2006, in forum: Microsoft Outlook Form Programming
    Replies:
    1
    Views:
    441
    Sue Mosher [MVP-Outlook]
    Jan 20, 2006
  3. Guest

    Populate Subject line with form values

    Guest, Nov 3, 2006, in forum: Microsoft Outlook Form Programming
    Replies:
    3
    Views:
    290
    Guest
    Nov 3, 2006
  4. Guest

    Populate Message field based on custom field

    Guest, Sep 5, 2007, in forum: Microsoft Outlook Form Programming
    Replies:
    8
    Views:
    335
    mattmansd
    Sep 7, 2007
  5. Mr Reorg

    Help needed to auto populate Subject field -Outlook 2003 custom ms

    Mr Reorg, Aug 1, 2008, in forum: Microsoft Outlook Form Programming
    Replies:
    6
    Views:
    2,578
    Ken Slovak - [MVP - Outlook]
    Aug 2, 2008
Loading...

Share This Page