I have a macro programmed in VBA to fill a word table with fields of data
from outlook journal entries. I am using the approach Sue Mosher describes
in her book Listing 22.11 on page 509, which uses the following code syntax
to put data into row x and column y of a word table:
objTable.Cell(x,y).Range.InsertAfter _
Myitem.UserProperties.Find("string"), where in my case "string" is used
as a user defined value that is bound to a textbox.
For bound values that are type of Text, this works fine. My problem is that
oone of the bound values to one of the textboxes is a Keyword and another is
type Yes/No.
Can anyone advise me as to how to change the code syntax on
MyItem.UserProperties to pick up the value of the Keyword or Yes/No value and
insert it into the cell of the WORD table?????

--
John E.

Either add a little code to set a return "Yes" and "No" strings for the appropriate value or use a checkbox form field as discussed on page 502.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"John E." wrote in message ...
I have a macro programmed in VBA to fill a word table with fields of data
from outlook journal entries. I am using the approach Sue Mosher describes
in her book Listing 22.11 on page 509, which uses the following code syntax
to put data into row x and column y of a word table:
objTable.Cell(x,y).Range.InsertAfter _
Myitem.UserProperties.Find("string"), where in my case "string" is used
as a user defined value that is bound to a textbox.
For bound values that are type of Text, this works fine. My problem is that
oone of the bound values to one of the textboxes is a Keyword and another is
type Yes/No.
Can anyone advise me as to how to change the code syntax on
MyItem.UserProperties to pick up the value of the Keyword or Yes/No value and
insert it into the cell of the WORD table?????

--
John E.

Thanks for response, Sue.
Understand about the Yes/No field, but do you have any suggestion as to how
I get the Keyword values into th cell of the word table...doesn't appear that
UsserProperties.Find("string") will work even the the Keywords are text.
--
John E.


"Sue Mosher [MVP-Outlook]" wrote:

Either add a little code to set a return "Yes" and "No" strings for the appropriate value or use a checkbox form field as discussed on page 502.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"John E." wrote in message ...
I have a macro programmed in VBA to fill a word table with fields of data
from outlook journal entries. I am using the approach Sue Mosher describes
in her book Listing 22.11 on page 509, which uses the following code syntax
to put data into row x and column y of a word table:
objTable.Cell(x,y).Range.InsertAfter _
Myitem.UserProperties.Find("string"), where in my case "string" is used
as a user defined value that is bound to a textbox.
For bound values that are type of Text, this works fine. My problem is that
oone of the bound values to one of the textboxes is a Keyword and another is
type Yes/No.
Can anyone advise me as to how to change the code syntax on
MyItem.UserProperties to pick up the value of the Keyword or Yes/No value and
insert it into the cell of the WORD table?????

--
John E.

See http://support.microsoft.com/kb/201099; probably the best approach is to go through the control on the form that displays the keywords field.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"John E." wrote in message ...
do you have any suggestion as to how
I get the Keyword values into th cell of the word table...doesn't appear that
UsserProperties.Find("string") will work even the the Keywords are text.


"John E." wrote in message ...
I have a macro programmed in VBA to fill a word table with fields of data
from outlook journal entries. I am using the approach Sue Mosher describes
in her book Listing 22.11 on page 509, which uses the following code syntax
to put data into row x and column y of a word table:
objTable.Cell(x,y).Range.InsertAfter _
Myitem.UserProperties.Find("string"), where in my case "string" is used
as a user defined value that is bound to a textbox.
For bound values that are type of Text, this works fine. My problem is that
oone of the bound values to one of the textboxes is a Keyword and another is
type Yes/No.
Can anyone advise me as to how to change the code syntax on
MyItem.UserProperties to pick up the value of the Keyword or Yes/No value and
insert it into the cell of the WORD table?????