![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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! |
Ads |
#2
|
|||
|
|||
![]()
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! |
#3
|
|||
|
|||
![]()
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! |
#4
|
|||
|
|||
![]()
FYI~ I used the code and it works perfectly...
![]() "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! |
#5
|
|||
|
|||
![]()
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! |
#6
|
|||
|
|||
![]()
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! |
#7
|
|||
|
|||
![]()
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! |
#8
|
|||
|
|||
![]()
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! |
#9
|
|||
|
|||
![]()
ahhh I see what you mean
![]() 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! |
#10
|
|||
|
|||
![]()
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? |
|
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calendar to Word Template | LPS | Outlook - Calandaring | 4 | March 6th 06 03:01 PM |
Outlook Calendar to Word: Using the Olcalndr.dot Template | LPS | Outlook - Calandaring | 0 | March 2nd 06 04:25 PM |
Automatically transfer contact details into a Word template | TheDufster | Outlook - Using Contacts | 1 | February 13th 06 06:01 PM |
Outlook Printing Problem | Brian C | Outlook - Installation | 0 | January 24th 06 03:10 AM |
How do you delete a customized form in Outlook? | IT Trainer | Outlook - Using Forms | 1 | January 10th 06 04:36 PM |