Problem Printing Customized Outlook Form using Word Template
 

I created an OL form and used the Sub cmdPrint_Click code to print the form
data. I got the oDoc.FormFields ("FieldName").Result = item.userproperties
("FieldName") part working. However, I'm having trouble with the checkboxes
and radio buttons. I've tried using oDoc.FormFields("FieldName").CheckBox =
item.userproperties("FieldName") but it doesn't work. Maybe I'm missing
something or is there a different code that I need to use to transfer the
data to the Word template?

I hope someone has the answer to this. I've searched online and in Word and
Outlook books to no avail. Thank you!

Problem Printing Customized Outlook Form using Word Template
 

You should to set the check box's Value property explictly, and the expression you set it to must be a True/False expression:

oDoc.FormFields("FieldName").CheckBox.Value = item.userproperties("FieldName")
--
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


"ajkim001" wrote in message ...
I created an OL form and used the Sub cmdPrint_Click code to print the form
data. I got the oDoc.FormFields ("FieldName").Result = item.userproperties
("FieldName") part working. However, I'm having trouble with the checkboxes
and radio buttons. I've tried using oDoc.FormFields("FieldName").CheckBox =
item.userproperties("FieldName") but it doesn't work. Maybe I'm missing
something or is there a different code that I need to use to transfer the
data to the Word template?

I hope someone has the answer to this. I've searched online and in Word and
Outlook books to no avail. Thank you!

Problem Printing Customized Outlook Form using Word Template
 

Thank you so much Sue. I will try using the value property.
And how would this work with a radio button? Would it be the same code but
"OptionButton" in place of "CheckBox"?


"Sue Mosher [MVP-Outlook]" wrote:

You should to set the check box's Value property explictly, and the expression you set it to must be a True/False expression:

oDoc.FormFields("FieldName").CheckBox.Value = item.userproperties("FieldName")
--
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


"ajkim001" wrote in message ...
I created an OL form and used the Sub cmdPrint_Click code to print the form
data. I got the oDoc.FormFields ("FieldName").Result = item.userproperties
("FieldName") part working. However, I'm having trouble with the checkboxes
and radio buttons. I've tried using oDoc.FormFields("FieldName").CheckBox =
item.userproperties("FieldName") but it doesn't work. Maybe I'm missing
something or is there a different code that I need to use to transfer the
data to the Word template?

I hope someone has the answer to this. I've searched online and in Word and
Outlook books to no avail. Thank you!

Problem Printing Customized Outlook Form using Word Template
 

FYI~ I used the code and it works perfectly... :o)

"Sue Mosher [MVP-Outlook]" wrote:

You should to set the check box's Value property explictly, and the expression you set it to must be a True/False expression:

oDoc.FormFields("FieldName").CheckBox.Value = item.userproperties("FieldName")
--
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


"ajkim001" wrote in message ...
I created an OL form and used the Sub cmdPrint_Click code to print the form
data. I got the oDoc.FormFields ("FieldName").Result = item.userproperties
("FieldName") part working. However, I'm having trouble with the checkboxes
and radio buttons. I've tried using oDoc.FormFields("FieldName").CheckBox =
item.userproperties("FieldName") but it doesn't work. Maybe I'm missing
something or is there a different code that I need to use to transfer the
data to the Word template?

I hope someone has the answer to this. I've searched online and in Word and
Outlook books to no avail. Thank you!

Problem Printing Customized Outlook Form using Word Template
 

Sorry, but I've never seen an option button control in a Word document. How did you do that?

--
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


"ajkim001" wrote in message ...
Thank you so much Sue. I will try using the value property.
And how would this work with a radio button? Would it be the same code but
"OptionButton" in place of "CheckBox"?


"Sue Mosher [MVP-Outlook]" wrote:

You should to set the check box's Value property explictly, and the expression you set it to must be a True/False expression:

oDoc.FormFields("FieldName").CheckBox.Value = item.userproperties("FieldName")


"ajkim001" wrote in message ...
I created an OL form and used the Sub cmdPrint_Click code to print the form
data. I got the oDoc.FormFields ("FieldName").Result = item.userproperties
("FieldName") part working. However, I'm having trouble with the checkboxes
and radio buttons. I've tried using oDoc.FormFields("FieldName").CheckBox =
item.userproperties("FieldName") but it doesn't work. Maybe I'm missing
something or is there a different code that I need to use to transfer the
data to the Word template?

I hope someone has the answer to this. I've searched online and in Word and
Outlook books to no avail. Thank you!

Problem Printing Customized Outlook Form using Word Template
 

I've never done it before either. I was wondering if it was even possible.
I guess I'll just have to change the Outlook form to use checkboxes instead
of radio buttons.

I apologize but I have another question. Now that I've got the script to
work, I'm having a problem with the oDoc.FormFields' appearing in the
printouts.
To better explain, I have written the code and what appears on the printed
form.
Code:
oDoc.FormFields("NewspaperOrMagazine").Result =
item.userproperties("Newspaper or Magazine")
Printed form:
[ ] Newspaper/Magazine: NewspaperOrMagazine

It doesn't show this in all the fields, just a few. I can't seem to figure
it out.


"Sue Mosher [MVP-Outlook]" wrote:

Sorry, but I've never seen an option button control in a Word document. How did you do that?

--
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


"ajkim001" wrote in message ...
Thank you so much Sue. I will try using the value property.
And how would this work with a radio button? Would it be the same code but
"OptionButton" in place of "CheckBox"?


"Sue Mosher [MVP-Outlook]" wrote:

You should to set the check box's Value property explictly, and the expression you set it to must be a True/False expression:

oDoc.FormFields("FieldName").CheckBox.Value = item.userproperties("FieldName")


"ajkim001" wrote in message ...
I created an OL form and used the Sub cmdPrint_Click code to print the form
data. I got the oDoc.FormFields ("FieldName").Result = item.userproperties
("FieldName") part working. However, I'm having trouble with the checkboxes
and radio buttons. I've tried using oDoc.FormFields("FieldName").CheckBox =
item.userproperties("FieldName") but it doesn't work. Maybe I'm missing
something or is there a different code that I need to use to transfer the
data to the Word template?

I hope someone has the answer to this. I've searched online and in Word and
Outlook books to no avail. Thank you!

Problem Printing Customized Outlook Form using Word Template
 

Why change the Outlook form? It's Word that doesn't have option buttons fields. You can decide how you want to show the property value in the Word document -- either with checkbox fields or text fields.

Sorry, but I don't understand what the "this" in "show this" is.

--
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


"ajkim001" wrote in message ...
I've never done it before either. I was wondering if it was even possible.
I guess I'll just have to change the Outlook form to use checkboxes instead
of radio buttons.

I apologize but I have another question. Now that I've got the script to
work, I'm having a problem with the oDoc.FormFields' appearing in the
printouts.
To better explain, I have written the code and what appears on the printed
form.
Code:
oDoc.FormFields("NewspaperOrMagazine").Result =
item.userproperties("Newspaper or Magazine")
Printed form:
[ ] Newspaper/Magazine: NewspaperOrMagazine

It doesn't show this in all the fields, just a few. I can't seem to figure
it out.


"Sue Mosher [MVP-Outlook]" wrote:

Sorry, but I've never seen an option button control in a Word document. How did you do that?


"ajkim001" wrote in message ...
Thank you so much Sue. I will try using the value property.
And how would this work with a radio button? Would it be the same code but
"OptionButton" in place of "CheckBox"?


"Sue Mosher [MVP-Outlook]" wrote:

You should to set the check box's Value property explictly, and the expression you set it to must be a True/False expression:

oDoc.FormFields("FieldName").CheckBox.Value = item.userproperties("FieldName")


"ajkim001" wrote in message ...
I created an OL form and used the Sub cmdPrint_Click code to print the form
data. I got the oDoc.FormFields ("FieldName").Result = item.userproperties
("FieldName") part working. However, I'm having trouble with the checkboxes
and radio buttons. I've tried using oDoc.FormFields("FieldName").CheckBox =
item.userproperties("FieldName") but it doesn't work. Maybe I'm missing
something or is there a different code that I need to use to transfer the
data to the Word template?

I hope someone has the answer to this. I've searched online and in Word and
Outlook books to no avail. Thank you!

Problem Printing Customized Outlook Form using Word Template
 

Sorry I've posted this in the wrong group...still any replies are welcome!

"ajkim001" wrote:

I created an OL form and used the Sub cmdPrint_Click code to print the form
data. I got the oDoc.FormFields ("FieldName").Result = item.userproperties
("FieldName") part working. However, I'm having trouble with the checkboxes
and radio buttons. I've tried using oDoc.FormFields("FieldName").CheckBox =
item.userproperties("FieldName") but it doesn't work. Maybe I'm missing
something or is there a different code that I need to use to transfer the
data to the Word template?

I hope someone has the answer to this. I've searched online and in Word and
Outlook books to no avail. Thank you!

Problem Printing Customized Outlook Form using Word Template
 

ahhh I see what you mean :o)
How can I show the value of the option button in the Outlook form to appear
as a text field in the Word doc?

I apologize for not being able to better explain what it is that I am
seeing. Perhaps I will post my question again when I come up with a better
description of the problem.

"Sue Mosher [MVP-Outlook]" wrote:

Why change the Outlook form? It's Word that doesn't have option buttons fields. You can decide how you want to show the property value in the Word document -- either with checkbox fields or text fields.

Sorry, but I don't understand what the "this" in "show this" is.

--
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


"ajkim001" wrote in message ...
I've never done it before either. I was wondering if it was even possible.
I guess I'll just have to change the Outlook form to use checkboxes instead
of radio buttons.

I apologize but I have another question. Now that I've got the script to
work, I'm having a problem with the oDoc.FormFields' appearing in the
printouts.
To better explain, I have written the code and what appears on the printed
form.
Code:
oDoc.FormFields("NewspaperOrMagazine").Result =
item.userproperties("Newspaper or Magazine")
Printed form:
[ ] Newspaper/Magazine: NewspaperOrMagazine

It doesn't show this in all the fields, just a few. I can't seem to figure
it out.


"Sue Mosher [MVP-Outlook]" wrote:

Sorry, but I've never seen an option button control in a Word document. How did you do that?


"ajkim001" wrote in message ...
Thank you so much Sue. I will try using the value property.
And how would this work with a radio button? Would it be the same code but
"OptionButton" in place of "CheckBox"?


"Sue Mosher [MVP-Outlook]" wrote:

You should to set the check box's Value property explictly, and the expression you set it to must be a True/False expression:

oDoc.FormFields("FieldName").CheckBox.Value = item.userproperties("FieldName")


"ajkim001" wrote in message ...
I created an OL form and used the Sub cmdPrint_Click code to print the form
data. I got the oDoc.FormFields ("FieldName").Result = item.userproperties
("FieldName") part working. However, I'm having trouble with the checkboxes
and radio buttons. I've tried using oDoc.FormFields("FieldName").CheckBox =
item.userproperties("FieldName") but it doesn't work. Maybe I'm missing
something or is there a different code that I need to use to transfer the
data to the Word template?

I hope someone has the answer to this. I've searched online and in Word and
Outlook books to no avail. Thank you!

Problem Printing Customized Outlook Form using Word Template
 

The details are going to depend on the nature of the option button(s). Is it a set of buttons bound to one Outlook property? (What kind of property?) Then you may be able to handle just like a text 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


"ajkim001" wrote in message ...

How can I show the value of the option button in the Outlook form to appear
as a text field in the Word doc?

Problem Printing Customized Outlook Form using Word Template
 

In case it's helpful to anyone, this is what I used to deal with the problem
(in can be adapted for either option buttons or checkboxes):

For counter = 1 to intBkList
strField = Trim(objWord.ActiveDocument.Bookmarks(counter))
Set objPage =Item.GetInspector.ModifiedFormPages("Message")
Set objControl = objPage.Controls(strField)
strField1 = objControl.Value
If strField1 = True then
strField2 = "¤"
ElseIf strField1 = False then
strField2 = "¡"
Else
strField2 = strField1
End If
objWord.ActiveDocument.Bookmarks(strField).Range.T ext = Cstr(strField2)
Next

Forget option buttons/check boxes in Word: it's only being used for the
printout so make sure the correct areas of your template are formatted to
Wingdings and use this code to drop in the right symbol!


"ajkim001" wrote:

FYI~ I used the code and it works perfectly... :o)

"Sue Mosher [MVP-Outlook]" wrote:

You should to set the check box's Value property explictly, and the expression you set it to must be a True/False expression:

oDoc.FormFields("FieldName").CheckBox.Value = item.userproperties("FieldName")
--
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


"ajkim001" wrote in message ...
I created an OL form and used the Sub cmdPrint_Click code to print the form
data. I got the oDoc.FormFields ("FieldName").Result = item.userproperties
("FieldName") part working. However, I'm having trouble with the checkboxes
and radio buttons. I've tried using oDoc.FormFields("FieldName").CheckBox =
item.userproperties("FieldName") but it doesn't work. Maybe I'm missing
something or is there a different code that I need to use to transfer the
data to the Word template?

I hope someone has the answer to this. I've searched online and in Word and
Outlook books to no avail. Thank you!

Problem Printing Customized Outlook Form using Word Template
 

I tried using that code but I get the following error - "MS Word: The
requested member of the collection does not exist.".

Daniel

-=-=-=-=-=-=-=

"ajkim001" wrote:

I created an OL form and used the Sub cmdPrint_Click code to print the form
data. I got the oDoc.FormFields ("FieldName").Result = item.userproperties
("FieldName") part working. However, I'm having trouble with the checkboxes
and radio buttons. I've tried using oDoc.FormFields("FieldName").CheckBox =
item.userproperties("FieldName") but it doesn't work. Maybe I'm missing
something or is there a different code that I need to use to transfer the
data to the Word template?

I hope someone has the answer to this. I've searched online and in Word and
Outlook books to no avail. Thank you!

Problem Printing Customized Outlook Form using Word Template
 

Hi Daniel

I'm assuming you're answering my message (but I may be wrong):

For counter = 1 to intBkList
strField = Trim(objWord.ActiveDocument.Bookmarks(counter))
....
objWord.ActiveDocument.Bookmarks(strField).Range.T ext = Cstr(strField2)
....

If you're getting the Word error message it must be to do with one of the
lines I've reproduced above. It could mean Word isn't finding the particular
bookmark so I guess your "counter" variable has reached a number for which
there's no equivalent index for a bookmark in the active document. Have you
set intBkList too high?

"Daniel Reyes" wrote:

I tried using that code but I get the following error - "MS Word: The
requested member of the collection does not exist.".

Daniel

-=-=-=-=-=-=-=

"ajkim001" wrote:

I created an OL form and used the Sub cmdPrint_Click code to print the form
data. I got the oDoc.FormFields ("FieldName").Result = item.userproperties
("FieldName") part working. However, I'm having trouble with the checkboxes
and radio buttons. I've tried using oDoc.FormFields("FieldName").CheckBox =
item.userproperties("FieldName") but it doesn't work. Maybe I'm missing
something or is there a different code that I need to use to transfer the
data to the Word template?

I hope someone has the answer to this. I've searched online and in Word and
Outlook books to no avail. Thank you!

Problem Printing Customized Outlook Form using Word Template
 

In article ,
=?Utf-8?B?RGFuaWVsIFJleWVz?= wrote:
I tried using that code but I get the following error - "MS Word: The
requested member of the collection does not exist.".

Take a look at this thread at www.outlookcode.com:

http://www.outlookcode.com/threads.a...essageid=16377
How to get at the values of user defined fields on a custom form?

Note Sue's comment: Sue Mosher 10-Feb-2006 06:48
Because UserProperties is for custom fields, not built-in fields. If you
have Outlook 2003, you can use ItemProperties for both.

Sue also has a page about the syntax for using fields in scripts, but I
can't find it today. You should try again later.

--
Hollis Paul
Mukilteo, WA USA

Problem Printing Customized Outlook Form using Word Template
 

That page is at http://www.outlookcode.com/d/propsyntax.htm

--
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

"Hollis Paul [MVP - Outlook]" wrote in message ...
In article ,
=?Utf-8?B?RGFuaWVsIFJleWVz?= wrote:
I tried using that code but I get the following error - "MS Word: The
requested member of the collection does not exist.".

Take a look at this thread at www.outlookcode.com:

http://www.outlookcode.com/threads.a...essageid=16377
How to get at the values of user defined fields on a custom form?

Note Sue's comment: Sue Mosher 10-Feb-2006 06:48
Because UserProperties is for custom fields, not built-in fields. If you
have Outlook 2003, you can use ItemProperties for both.

Sue also has a page about the syntax for using fields in scripts, but I
can't find it today. You should try again later.

--
Hollis Paul
Mukilteo, WA USA

Problem Printing Customized Outlook Form using Word Template
 

In article , Sue Mosher
[MVP-Outlook] wrote:
That page is at http://www.outlookcode.com/d/propsyntax.htm

Thank you, Sue. I searched on syntax and it never came up. I will go
read it and find a good keyword to use.

--
Hollis Paul
Mukilteo, WA USA