Combining data from two fields

Status
Not open for further replies.
J

JKR in VA

I am using a message form in Outlook. I want the value of field "A" to equal

what is typed into "A", appended to what is typed into field "B".

In my trials, I cannot get the information typed into "A" to stay, it gets

removed and replaced by the data in "B".

Would someone please help me with this?

Thanks!!!!
 
S

Sue Mosher [MVP]

Try using the CustomPropertyChange event, as demonstrated at

http://www.outlookcode.com/article.aspx?ID=38.

Sue Mosher

"JKR in VA" <JKR in VA> wrote in message

news:B85E904D-725F-4019-8B3B-6012662ACC07@microsoft.com...
> I am using a message form in Outlook. I want the value of field "A" to
> equal
> what is typed into "A", appended to what is typed into field "B".
> In my trials, I cannot get the information typed into "A" to stay, it gets
> removed and replaced by the data in "B".
> Would someone please help me with this?

> Thanks!!!!
 
J

JKR in VA

Hi Sue,

Thank you for your help. This is beyond my ability level.

What I want to end up with is requiring the user of the form to fill out

either field "A" or field "B". I am using the text from these fields in the

subject line.

Is there a way with just the built in standard functions to achieve this?

"Sue Mosher [MVP]" wrote:


> Try using the CustomPropertyChange event, as demonstrated at
> http://www.outlookcode.com/article.aspx?ID=38.

> > Sue Mosher
> > >

> "JKR in VA" <JKR in VA> wrote in message
> news:B85E904D-725F-4019-8B3B-6012662ACC07@microsoft.com...
> >I am using a message form in Outlook. I want the value of field "A" to
> >equal
> > what is typed into "A", appended to what is typed into field "B".
> > In my trials, I cannot get the information typed into "A" to stay, it gets
> > removed and replaced by the data in "B".
> > Would someone please help me with this?
> > Thanks!!!!


>
 
S

Sue Mosher [MVP]

I'm confused. The description in your latest message doesn't match what you

originally posted. Are you trying to do *both* validation and appending text

from one field to the value of another? Or are you taking the values of two

fields to create the value of a third?

FWIW, I have found over more than a decade of work, that VBScript behind a

custom form is not beyond anyone's ability. I would encourage you to read

through the examples and then ask specific questions if there's something

you don't understand.

Sue Mosher

"JKR in VA" <JKRinVA> wrote in message

news:FBDCDEF8-FD4C-43F4-B5A3-6C59973137F5@microsoft.com...
> Hi Sue,
> Thank you for your help. This is beyond my ability level.
> What I want to end up with is requiring the user of the form to fill out
> either field "A" or field "B". I am using the text from these fields in
> the
> subject line.
> Is there a way with just the built in standard functions to achieve this?

> "Sue Mosher [MVP]" wrote:
>
> > Try using the CustomPropertyChange event, as demonstrated at
> > http://www.outlookcode.com/article.aspx?ID=38.
>

>> > > Sue Mosher
> > >> >> >
>
>> "JKR in VA" <JKR in VA> wrote in message
> > news:B85E904D-725F-4019-8B3B-6012662ACC07@microsoft.com...
> > >I am using a message form in Outlook. I want the value of field "A" to
> > >equal
> > > what is typed into "A", appended to what is typed into field "B".
> > > In my trials, I cannot get the information typed into "A" to stay, it
> > > gets
> > > removed and replaced by the data in "B".
> > > Would someone please help me with this?
> >> > Thanks!!!!

>

>
>>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
kburrows Outlook or Phone Combining Contacts? Using Outlook 0
RBLampert Combining PSTs Using Outlook 1
D Combining date and time into one field Outlook VBA and Custom Forms 2
mwh1962 combining pst & ost calendars & contacts with Office 365 Using Outlook 5
W combining outlook accounts Using Outlook 0
M How to set exchange calendar as default when combining with Internet calendar Using Outlook 2
D Outlook 2010 and combining multiple rules into one? Using Outlook 4
D Combining multiple messages into a single task Using Outlook 3
C Populate form data into message body Outlook VBA and Custom Forms 1
Christopher M Saving Data: Don't check certain folders Using Outlook 2
Christopher M Importing " Old Skool" Data Using Outlook 0
W Create a Quick Step or VBA to SAVE AS PDF in G:|Data|Client File Outlook VBA and Custom Forms 1
Wotme create email only data file Using Outlook 1
V Backup Calendar, Contacts, Tasks in an POP3 data file Using Outlook 3
e_a_g_l_e_p_i Changing where data .pst is saved to Using Outlook 3
J Deliver new messages to New or Existing Data File? Using Outlook 2
G Outlook 2016: Want IMAP Data Files on My D: Drive and Not C: Drive Using Outlook 1
T vba extract data from msg file as attachment file of mail message Outlook VBA and Custom Forms 1
D Outlook 2016 Unable to load Outlook data pst file Using Outlook 5
V Form data not sending for some users Outlook VBA and Custom Forms 2
D Outlook VBA error extracting property data from GetRules collection Outlook VBA and Custom Forms 10
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 10
T How can Exchange be configured to sync/push one-way so that the server data can't be affected Exchange Server Administration 0
T Extract Data From Outlook Tasks Using Outlook 0
F outlook.com Exchane Server corrupts data Since September 2019 Using Outlook.com accounts in Outlook 6
T Extract Data From Outlook Tasks Using Outlook 0
E To convert imported data to custom fields in Task list Outlook VBA and Custom Forms 1
R "Can't store Outlook data files under the AppData folder. Please choose another folder." Using Outlook 6
C How to export Outlook data to csv? Using Outlook 0
RBLampert Assigning a newly (re)created e-mail account to a specific .pst data file Using Outlook 2
S newly added shared mailboxes downloading 500GB data a day Exchange Server Administration 1
M Using field names to capture a data element Using Outlook 0
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
M Outlook 2016 Requesting data from server Using Outlook 0
G Entered data in custom field goes in card and does not stay in list view Outlook VBA and Custom Forms 1
E Copying data from e-mail attachement to EXCEL file via macro Outlook VBA and Custom Forms 38
Sofia Manni Some of my favorite data in outlook. Using Outlook 2
A Outlook 2016 Will Not Show Any Data In the People Pane Using Outlook 17
A Script to fetch data from mails in restricted collection and sending them to excel Using Outlook 1
Commodore Search cannot complete the indexing of your Outlook data Using Outlook 6
P Microsoft Outlook is requesting data from the server Using Outlook 2
S BCM Auto Backup Data and Customizations BCM (Business Contact Manager) 6
K How to access emails found to be located in "Top of Outlook data file"? Using Outlook 3
M adding corresponding contact form data on a mass scale Using Outlook 5
J Calendar data can be viewed on Outlook.com, but no longer syncs to Outlook 2013 Using Outlook.com accounts in Outlook 3
M Retrieve data from GAL and put it in Clipboard Using Outlook 1
G How to Copy Multi Select Listbox Data to Appointment Outlook VBA and Custom Forms 3
G Using Data From Combo Box in Appointment Body Outlook VBA and Custom Forms 6
P How to copy and append data from Outlook 2016 message into Excel 2016 workbook Using Outlook 0
Diane Poremsky Set Another Data File as Default When Using an Exchange Account Using Outlook 0

Similar threads

Top