|
| 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
January 24th 06, 11:17 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
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! 
|
|
#2
January 25th 06, 12:01 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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!
|
|
#3
January 25th 06, 12:37 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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!
|
|
#4
January 25th 06, 03:04 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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!
|
|
#5
January 25th 06, 05:20 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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!
|
|
#6
January 25th 06, 05:32 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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!
|
|
#7
January 25th 06, 12:56 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Problem Printing Customized Outlook Form using Word Template
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!
|
|
#8
January 31st 06, 11:40 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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... )"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!
|
|
#9
January 26th 06, 02:41 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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!
|
|
#10
April 27th 06, 03:11 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
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!
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 |
Hybrid Mode
