Custom formula for columns

Status
Not open for further replies.

Exceleratevba

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Office 365 Exchange
Hi,

Is it possible to create the following custom formula for an Outlook column.

I have a column called "Actioned By" on a public mailbox that allows in-cell editing that everyone currently types in their name manually on each email. Is it possible to have a formula that if you type in a letter, it populates the rest of the users name?

For instance, if someone types J, it populates "Jermain" in the column cell based on the formula or if they type R it populates "Rosa" and so forth.
 

Exceleratevba

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Office 365 Exchange
In the view, no. In a custom form, with code behind it, you could, but recent security changes make using custom forms more difficult.
Is there any other way to (semi)automate the process instead of having each user manually type in their name each time?

What about being able to create a Custom column with a popup list similar to the Importance column?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
You can't use lists in the custom views. You could use a macro - Create a custom field for Outlook messages

Assuming each user will enter their own name, change this line:
strNote = InputBox("Current Value: " & strCurrent, "Edit the Notes field", strCurrent)
to
strNote = "Your name"

you'll need to change the field name too. (unless you named it My Notes too. :) )
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
Potty Ash MS Outlook 2010 custom form - validation or formula to request user to check a checkbox Outlook VBA and Custom Forms 16
S Create a clickable custom column field Outlook VBA and Custom Forms 0
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
M VbScript for Command Button on Contacts Custom Form Using Outlook 1
G Other users can't see P.2 with custom fields in Form Outlook VBA and Custom Forms 0
O Create a custom contact form - questions before messing things up... Outlook VBA and Custom Forms 4
S Reference Custom Fields with VBA Outlook VBA and Custom Forms 2
L Custom Form Tutoral? Outlook VBA and Custom Forms 6
D Lost Access to Custom Form Outlook VBA and Custom Forms 4
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1
S Outlook Custom Form Scripting only working when clicking on "Run this form" Outlook VBA and Custom Forms 2
A Custom VBA to sort emails into folders Outlook VBA and Custom Forms 0
Victor_50 Outlook 2013 Custom Contact Form starts with "E-mail 2" Outlook VBA and Custom Forms 2
C Custom Form (seperate layout pages and message reading pane) Outlook VBA and Custom Forms 0
C Reading Pane for Custom Form Outlook VBA and Custom Forms 2
M Custom Calendar Print Suggestions? Using Outlook 0
K Custom Category Colors Using Outlook 2
N Custom Form Controls Not Visible To Recipient Outlook VBA and Custom Forms 3
E To convert imported data to custom fields in Task list Outlook VBA and Custom Forms 1
Randy Redekopp How To Merge Contact Info to Email Custom Form Template Using Outlook 2
D Problem with custom form including _DocSiteControl1 Outlook VBA and Custom Forms 0
C Custom Outlook Form - Populate Information from Radio Button / Check Box Using Outlook 0
H Custom Signature Not Displayed When Account Selected Outlook VBA and Custom Forms 10
W Message class changes of a custom form changes to the default form Using Outlook 2
A Possible to hide ribbon with custom appointment form? Outlook VBA and Custom Forms 3
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
Andrew Quirl Custom form to route requests based on input criteria Outlook VBA and Custom Forms 1
D Using a VBA Custom Form to Send Reoccurring Email Upon Task Completion Outlook VBA and Custom Forms 4
W Setting up a custom form Outlook VBA and Custom Forms 2
A Greyed out checkbox in custom form Outlook VBA and Custom Forms 4
Z Outlook Custom Form: Adding Dropdown(Project Code) at the end of subject Outlook VBA and Custom Forms 0
Z Adding dropdown list using custom form Outlook VBA and Custom Forms 7
G Entered data in custom field goes in card and does not stay in list view Outlook VBA and Custom Forms 1
witzker Correct Format of custom Yes/No Checkboxes Outlook VBA and Custom Forms 0
O Searching for Custom Flags Using Outlook 3
J autocomplete function in custom form Using Outlook 1
S Custom user fields in received messages Outlook VBA and Custom Forms 1
J Backup .OST - Custom Contact Forms, Defined Fields, Notes Using Outlook 1
D Custom form with html hyperlink Outlook VBA and Custom Forms 7
P Outlook custom fields "events" Using Outlook 0
D populating listbox on custom form from Access Outlook VBA and Custom Forms 7
D Custom Form Accept and Reject Command buttons Outlook VBA and Custom Forms 2
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7
H Custom autoforwarding, sending mail through outlook office 365 Using Outlook 1
J Custom form code doesn't run Outlook VBA and Custom Forms 2
R Custom Contact Form how to update when loaded. Outlook VBA and Custom Forms 6
G Copy Contact field to Appointment Custom Form Field Outlook VBA and Custom Forms 2
S Custom form with dropdown Using Outlook 0
P Custom form reverts from task Outlook VBA and Custom Forms 1
G How do I create a custom pick list in VB for an outlook automated email? Outlook VBA and Custom Forms 1
Similar threads


















































Top