Outlook Script Getting value of personnal added Fields (customised Froms)

  • Thread starter Thread starter bbnimda
  • Start date Start date
B

bbnimda

Hi it's me again

I'm unable to get value of fiels I added to my forms

I used new fields like combos and text, I tryed to get the value of these
fields in many way like

result = the_name_of_the_field
set result = Item.the_name_of_the_field

but no one give me a result


tks for help
 
Hi Sue, tks for your help but I still have question about scripting outlook

1) I used a personal OptionButton (boolean) and I failed to get the
value
2) I used an built in Outlook 2003 Properties and I'm unable tu get the
value of these fields because I didn't the name of the field how can'I
found it ?
3)I want to give a number to each task created with my customized form, is
there an outlook value I can Use

Tks in advance




"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le message
de e0K42%[email protected]...
Combo and text boxes are not fields. They're controls. See
http://www.outlookcode.com/d/propsyntax.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
1) SHow your code, please

2) Use the object browser -- F2 in Outlook VBA

3) You can use the built-in BIllingInformation or Mileage property or a custom property.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


bbnimda said:
Hi Sue, tks for your help but I still have question about scripting outlook

1) I used a personal OptionButton (boolean) and I failed to get the
value
2) I used an built in Outlook 2003 Properties and I'm unable tu get the
value of these fields because I didn't the name of the field how can'I
found it ?
3)I want to give a number to each task created with my customized form, is
there an outlook value I can Use

Tks in advance




"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le message
de e0K42%[email protected]...
Combo and text boxes are not fields. They're controls. See
http://www.outlookcode.com/d/propsyntax.htm


bbnimda said:
Hi it's me again

I'm unable to get value of fiels I added to my forms

I used new fields like combos and text, I tryed to get the value of these
fields in many way like

result = the_name_of_the_field
set result = Item.the_name_of_the_field

but no one give me a result


tks for help
Click to expand...
Click to expand...
 
Hi Sue,

1) I found The right " syntax "

2) I didn't found all what I'm looking for yet but I continue searching

3) Can U show me a part of code using this (Outlook Script pls) I didn't
found inough information about BIllingInformation


"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le message
de %[email protected]...
1) SHow your code, please

2) Use the object browser -- F2 in Outlook VBA

3) You can use the built-in BIllingInformation or Mileage property or a
custom property.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


bbnimda said:
Hi Sue, tks for your help but I still have question about scripting
outlook

1) I used a personal OptionButton (boolean) and I failed to get the
value
2) I used an built in Outlook 2003 Properties and I'm unable tu get the
value of these fields because I didn't the name of the field how can'I
found it ?
3)I want to give a number to each task created with my customized form, is
there an outlook value I can Use

Tks in advance




"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le
message
de e0K42%[email protected]...
Combo and text boxes are not fields. They're controls. See
http://www.outlookcode.com/d/propsyntax.htm


bbnimda said:
Hi it's me again

I'm unable to get value of fiels I added to my forms

I used new fields like combos and text, I tryed to get the value of these
fields in many way like

result = the_name_of_the_field
set result = Item.the_name_of_the_field

but no one give me a result


tks for help
Click to expand...
Click to expand...
 
2) Why don't you tell us what you're looking for?

3) It's just a simple text property.

Item.BillingInformation = "some value"
strValue = Item.BillingInformation

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


news.microsoft.com said:
2) I didn't found all what I'm looking for yet but I continue searching

3) Can U show me a part of code using this (Outlook Script pls) I didn't
found inough information about BIllingInformation


"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le message
de %[email protected]...

2) Use the object browser -- F2 in Outlook VBA

3) You can use the built-in BIllingInformation or Mileage property or a
custom property.

2) I used an built in Outlook 2003 Properties and I'm unable tu get the
value of these fields because I didn't the name of the field how can'I
found it ?
3)I want to give a number to each task created with my customized form, is
there an outlook value I can Use
Click to expand...
Click to expand...
 
Hi Sue I'm not enough good in english to explain correctly my Pb or what I
want to do so be patient ;)))

2) I use Built-in fields like "Société" in french in task I can
get the value of the field using "compagnies" but in Contact I still
not found the good name of the field I tryed "compagnies" & " company"
but nothing

3) I don't want use my own value, but I want to give a number (incremental)
to each task Created with my forms (counter) and display it in a field




"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le message
de news: (e-mail address removed)...
2) Why don't you tell us what you're looking for?

3) It's just a simple text property.

Item.BillingInformation = "some value"
strValue = Item.BillingInformation

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


news.microsoft.com said:
2) I didn't found all what I'm looking for yet but I continue searching

3) Can U show me a part of code using this (Outlook Script pls) I
didn't
found inough information about BIllingInformation


"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le
message
de %[email protected]...

2) Use the object browser -- F2 in Outlook VBA

3) You can use the built-in BIllingInformation or Mileage property or a
custom property.

2) I used an built in Outlook 2003 Properties and I'm unable tu get the
value of these fields because I didn't the name of the field how
can'I
found it ?
3)I want to give a number to each task created with my customized form,
is
there an outlook value I can Use
Click to expand...
Click to expand...
 
2) CompanyName

3) If a simple unique identifier will do, you can take the item's EntryID (set after the item is saved) and copy it into the field that you want to use to hold the ID. The value of the actual EntryID property may change if you move the item, but the value in the custom property won't.

My book demonstrates several other methods. You can download the sample code from http://www.outlookcode.com/member/book.aspx :

1) Get a GUID with the Session.CreateConversationIndex from CDO 1.21. (Listing 20.5)

2) Build an ID from the current date/time (Listing 20.6)

If you need a sequential number, not just a unique number, here are some methods you can use:

3) Use an autonumber table in SQL Server or Microsoft Access. (In my book, Listing 23.7 with Listing 23.4 or 23.3 to open the database)

4) In a custom Outlook form, republish the form after each use to reset the number. See http://www.outlookexchange.com/articles/ricardosilva/vbscriptoutforms.asp

5) Use an Excel worksheet that contains VBA code to increment the number. See http://www.microsoft.com/office/com...sers&mid=5489e140-9794-41b7-a9ba-1324e136ff3a

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


news.microsoft.com said:
Hi Sue I'm not enough good in english to explain correctly my Pb or what I
want to do so be patient ;)))

2) I use Built-in fields like "Société" in french in task I can
get the value of the field using "compagnies" but in Contact I still
not found the good name of the field I tryed "compagnies" & " company"
but nothing

3) I don't want use my own value, but I want to give a number (incremental)
to each task Created with my forms (counter) and display it in a field




"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le message
de news: (e-mail address removed)...
2) Why don't you tell us what you're looking for?

3) It's just a simple text property.

Item.BillingInformation = "some value"
strValue = Item.BillingInformation

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


news.microsoft.com said:
2) I didn't found all what I'm looking for yet but I continue searching

3) Can U show me a part of code using this (Outlook Script pls) I
didn't
found inough information about BIllingInformation


"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le
message
de %[email protected]...

2) Use the object browser -- F2 in Outlook VBA

3) You can use the built-in BIllingInformation or Mileage property or a
custom property.

2) I used an built in Outlook 2003 Properties and I'm unable tu get the
value of these fields because I didn't the name of the field how
can'I
found it ?
3)I want to give a number to each task created with my customized form,
is
there an outlook value I can Use
Click to expand...
Click to expand...
Click to expand...
 
Hi Sue,

2) It's Okay for CompanyName, but there's not a knowlege base (or other
way) to get the names of built-in fields ?

3) The EntryID is too long to use it but you link was very usefull to me
tks a lot

is there reseller in France for your Book ?


"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le message
de eT1%[email protected]...
2) CompanyName

3) If a simple unique identifier will do, you can take the item's EntryID
(set after the item is saved) and copy it into the field that you want to
use to hold the ID. The value of the actual EntryID property may change if
you move the item, but the value in the custom property won't.

My book demonstrates several other methods. You can download the sample code
from http://www.outlookcode.com/member/book.aspx :

1) Get a GUID with the Session.CreateConversationIndex from CDO 1.21.
(Listing 20.5)

2) Build an ID from the current date/time (Listing 20.6)

If you need a sequential number, not just a unique number, here are some
methods you can use:

3) Use an autonumber table in SQL Server or Microsoft Access. (In my book,
Listing 23.7 with Listing 23.4 or 23.3 to open the database)

4) In a custom Outlook form, republish the form after each use to reset the
number. See
http://www.outlookexchange.com/articles/ricardosilva/vbscriptoutforms.asp

5) Use an Excel worksheet that contains VBA code to increment the number.
See
http://www.microsoft.com/office/com...sers&mid=5489e140-9794-41b7-a9ba-1324e136ff3a

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


news.microsoft.com said:
Hi Sue I'm not enough good in english to explain correctly my Pb or what I
want to do so be patient ;)))

2) I use Built-in fields like "Société" in french in task I can
get the value of the field using "compagnies" but in Contact I
still
not found the good name of the field I tryed "compagnies" & " company"
but nothing

3) I don't want use my own value, but I want to give a number
(incremental)
to each task Created with my forms (counter) and display it in a field




"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le
message
de news: (e-mail address removed)...
2) Why don't you tell us what you're looking for?

3) It's just a simple text property.

Item.BillingInformation = "some value"
strValue = Item.BillingInformation

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


news.microsoft.com said:
2) I didn't found all what I'm looking for yet but I continue searching

3) Can U show me a part of code using this (Outlook Script pls) I
didn't
found inough information about BIllingInformation


"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le
message
de %[email protected]...

2) Use the object browser -- F2 in Outlook VBA

3) You can use the built-in BIllingInformation or Mileage property or a
custom property.

2) I used an built in Outlook 2003 Properties and I'm unable tu get
the
value of these fields because I didn't the name of the field how
can'I
found it ?
3)I want to give a number to each task created with my customized form,
is
there an outlook value I can Use
Click to expand...
Click to expand...
Click to expand...
 
1) There is. It's called the object browser -- F2 in VBA. Expanded with examples, it's also in the Outlook VBA Help file and online at MSDN.

2) I don't have information on French resellers, but the person who would is Miguel Sanchez Gatell, whose email address you can find at http://books.elsevier.com/uk/conten...ress&mscssid=8MGUXLWWXC0J9GAV77D15TE6FKG52DP3

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
1) I tryed but insuccessfully

For example I wanted to get the e-mail value (in contact) I tryed

Email1Adress
Email1AdressType
Email1DisplayName
Email1EntryID

but no One gave me the good result, so can U tell me why ?

Tks



"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le message
de [email protected]...
1) There is. It's called the object browser -- F2 in VBA. Expanded with
examples, it's also in the Outlook VBA Help file and online at MSDN.

2) I don't have information on French resellers, but the person who would is
Miguel Sanchez Gatell, whose email address you can find at
http://books.elsevier.com/uk/conten...ress&mscssid=8MGUXLWWXC0J9GAV77D15TE6FKG52DP3

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
You've misspelled the first two. Look at the object browser again, please.

What do you consider a "good" result?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


bbnimda said:
1) I tryed but insuccessfully

For example I wanted to get the e-mail value (in contact) I tryed

Email1Adress
Email1AdressType
Email1DisplayName
Email1EntryID

but no One gave me the good result, so can U tell me why ?

"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le message
de [email protected]...
1) There is. It's called the object browser -- F2 in VBA. Expanded with
examples, it's also in the Outlook VBA Help file and online at MSDN.

news.microsoft.com said:
2) It's Okay for CompanyName, but there's not a knowlege base (or other
way) to get the names of built-in fields ?
Click to expand...
Click to expand...
 
Arrffff ... yes you'r right (like every time) this stupid mistake took me
lot of time.

tks again Sue,



"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le message
de OJ7if%[email protected]...
You've misspelled the first two. Look at the object browser again, please.

What do you consider a "good" result?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


bbnimda said:
1) I tryed but insuccessfully

For example I wanted to get the e-mail value (in contact) I tryed

Email1Adress
Email1AdressType
Email1DisplayName
Email1EntryID

but no One gave me the good result, so can U tell me why ?

"Sue Mosher [MVP-Outlook]" <[email protected]> a écrit dans le
message
de [email protected]...
1) There is. It's called the object browser -- F2 in VBA. Expanded with
examples, it's also in the Outlook VBA Help file and online at MSDN.

news.microsoft.com said:
2) It's Okay for CompanyName, but there's not a knowlege base (or
other
way) to get the names of built-in fields ?
Click to expand...
Click to expand...
 
Back
Top