Problem Printing Customized Outlook Form using Word Template

G

Guest

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

Sue Mosher [MVP-Outlook]

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

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

Guest

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"?
 
S

Sue Mosher [MVP-Outlook]

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

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

Guest

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

Sue Mosher [MVP-Outlook]

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

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



ajkim001 said:
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 said:
Sorry, but I've never seen an option button control in a Word document. How did you do that?
Click to expand...
Click to expand...
 
G

Guest

ahhh I see what you mean :blush:)
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 said:
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

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



ajkim001 said:
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 said:
Sorry, but I've never seen an option button control in a Word document. How did you do that?

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


:

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


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!
Click to expand...
Click to expand...
Click to expand...
 
S

Sue Mosher [MVP-Outlook]

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

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

Guest

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.Text = 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!
 
G

Guest

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

Daniel

-=-=-=-=-=-=-=
 
G

Guest

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.Text = 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?
 
H

Hollis Paul [MVP - Outlook]

I tried using that code but I get the following error - "MS Word: The
requested member of the collection does not exist.".
Click to expand...
Take a look at this thread at www.outlookcode.com:

http://www.outlookcode.com/threads.aspx?forumid=3&messageid=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem getting Outlook custom form to print to Word 8
Printing Forms in OL2002 4
Outlook VBA Outlook 2003 SP3 Custom Form 5
Custom form prints blank Word template without field values... 3
outlook checkbox merge 1
Modifying a Form to append the resulting email's subject line 0
Out Look Form Printing Issue 1
outlook merge field 1

Top