![]() |
|
Custom Form Printing
Okay all I think I am making this more difficult then it needs to be so I
thought instead of doing that I would ask our group here for help. Created customized form with mutliple tabs and fields. I am trying to find the best way to print a customized contact form. The goal is to be able to print the contact form that is selected in a predined tempate automatically by pushing a print command button. Typically they are going to print a single contact at a a time. I am trying to figure out the best method to do this such as create and make it as seemless as possible to the end-user. Francine Otterson MVP - Outlook |
Custom Form Printing
Hi there Sue, thanks so much I will look at it. I am sure with my background
in doing this in Access is not helping it seems to be much different in Outlook. At least I know I am just missing something. I do have one more question for you - if I may. I created the form but realized that I did all the customizatio "user-defined" fields at the form level and not folder level. Now when I created a new sub-folder the items that are not on the form are not available under the folder level. Preventing me from adding them to mail-merge. Any way to rectify this easily. "Sue Mosher [MVP-Outlook]" wrote: Hi Francine! It *is* difficult, at least until you understand the technique. Outlook doesn't do WYSIWYG printing of custom forms. I always use the Word template method described at http://www.outlookcode.com/d/customprint.htm along with other various solutions. -- 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 "Francine Otterson" Francine wrote in message ... Okay all I think I am making this more difficult then it needs to be so I thought instead of doing that I would ask our group here for help. Created customized form with mutliple tabs and fields. I am trying to find the best way to print a customized contact form. The goal is to be able to print the contact form that is selected in a predined tempate automatically by pushing a print command button. Typically they are going to print a single contact at a a time. I am trying to figure out the best method to do this such as create and make it as seemless as possible to the end-user. Francine Otterson MVP - Outlook |
Custom Form Printing
You must add the fields to the folder, either manually or by writing a script or some VBA code that (a) creates a new post in the folder and (b) adds fields to it. Such a script is available at http://www.exchangeadmin.com/article...ticleid=23483; you don't have to register to download the code.
-- 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 "Francine Otterson" wrote in message ... Hi there Sue, thanks so much I will look at it. I am sure with my background in doing this in Access is not helping it seems to be much different in Outlook. At least I know I am just missing something. I do have one more question for you - if I may. I created the form but realized that I did all the customizatio "user-defined" fields at the form level and not folder level. Now when I created a new sub-folder the items that are not on the form are not available under the folder level. Preventing me from adding them to mail-merge. Any way to rectify this easily. "Sue Mosher [MVP-Outlook]" wrote: Hi Francine! It *is* difficult, at least until you understand the technique. Outlook doesn't do WYSIWYG printing of custom forms. I always use the Word template method described at http://www.outlookcode.com/d/customprint.htm along with other various solutions. "Francine Otterson" Francine wrote in message ... Okay all I think I am making this more difficult then it needs to be so I thought instead of doing that I would ask our group here for help. Created customized form with mutliple tabs and fields. I am trying to find the best way to print a customized contact form. The goal is to be able to print the contact form that is selected in a predined tempate automatically by pushing a print command button. Typically they are going to print a single contact at a a time. I am trying to figure out the best method to do this such as create and make it as seemless as possible to the end-user. Francine Otterson MVP - Outlook |
Custom Form Printing
First thank you for your help - I am making progress and the solution of
using the Word template to do what I need does seem to be the best option. But I am once again stuck and after trying for way too long on my own I decided to ask for help. I did check in you book and on the newgroups. I am sure the answer is there but I am missing it. I used the code in Ch 22 as I a guideline but I keep getting variable not defined for the following code. Seems the problem is Item.UserProperities. Sub FillFields(objDoc) Dim colFields Set colFields = objDoc.FormFields colFields("LabManagerName").Result = _ Item.UserProperites("Lab Manager Name") End Sub "Sue Mosher [MVP-Outlook]" wrote: You must add the fields to the folder, either manually or by writing a script or some VBA code that (a) creates a new post in the folder and (b) adds fields to it. Such a script is available at http://www.exchangeadmin.com/article...ticleid=23483; you don't have to register to download the code. -- 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 "Francine Otterson" wrote in message ... Hi there Sue, thanks so much I will look at it. I am sure with my background in doing this in Access is not helping it seems to be much different in Outlook. At least I know I am just missing something. I do have one more question for you - if I may. I created the form but realized that I did all the customizatio "user-defined" fields at the form level and not folder level. Now when I created a new sub-folder the items that are not on the form are not available under the folder level. Preventing me from adding them to mail-merge. Any way to rectify this easily. "Sue Mosher [MVP-Outlook]" wrote: Hi Francine! It *is* difficult, at least until you understand the technique. Outlook doesn't do WYSIWYG printing of custom forms. I always use the Word template method described at http://www.outlookcode.com/d/customprint.htm along with other various solutions. "Francine Otterson" Francine wrote in message ... Okay all I think I am making this more difficult then it needs to be so I thought instead of doing that I would ask our group here for help. Created customized form with mutliple tabs and fields. I am trying to find the best way to print a customized contact form. The goal is to be able to print the contact form that is selected in a predined tempate automatically by pushing a print command button. Typically they are going to print a single contact at a a time. I am trying to figure out the best method to do this such as create and make it as seemless as possible to the end-user. Francine Otterson MVP - Outlook |
Custom Form Printing
Is this code running inside the Outlook form? If not, you need to instantiate an Item object variable somewhere in your code to tell Outlook what item to work with.
-- 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 "Francine Otterson" wrote in message ... First thank you for your help - I am making progress and the solution of using the Word template to do what I need does seem to be the best option. But I am once again stuck and after trying for way too long on my own I decided to ask for help. I did check in you book and on the newgroups. I am sure the answer is there but I am missing it. I used the code in Ch 22 as I a guideline but I keep getting variable not defined for the following code. Seems the problem is Item.UserProperities. Sub FillFields(objDoc) Dim colFields Set colFields = objDoc.FormFields colFields("LabManagerName").Result = _ Item.UserProperites("Lab Manager Name") End Sub "Sue Mosher [MVP-Outlook]" wrote: You must add the fields to the folder, either manually or by writing a script or some VBA code that (a) creates a new post in the folder and (b) adds fields to it. Such a script is available at http://www.exchangeadmin.com/article...ticleid=23483; you don't have to register to download the code. "Francine Otterson" wrote in message ... Hi there Sue, thanks so much I will look at it. I am sure with my background in doing this in Access is not helping it seems to be much different in Outlook. At least I know I am just missing something. I do have one more question for you - if I may. I created the form but realized that I did all the customizatio "user-defined" fields at the form level and not folder level. Now when I created a new sub-folder the items that are not on the form are not available under the folder level. Preventing me from adding them to mail-merge. Any way to rectify this easily. "Sue Mosher [MVP-Outlook]" wrote: Hi Francine! It *is* difficult, at least until you understand the technique. Outlook doesn't do WYSIWYG printing of custom forms. I always use the Word template method described at http://www.outlookcode.com/d/customprint.htm along with other various solutions. "Francine Otterson" Francine wrote in message ... Okay all I think I am making this more difficult then it needs to be so I thought instead of doing that I would ask our group here for help. Created customized form with mutliple tabs and fields. I am trying to find the best way to print a customized contact form. The goal is to be able to print the contact form that is selected in a predined tempate automatically by pushing a print command button. Typically they are going to print a single contact at a a time. I am trying to figure out the best method to do this such as create and make it as seemless as possible to the end-user. Francine Otterson MVP - Outlook |
Custom Form Printing
Sue, I thought it was running in the form. Well at least when I open the
form the macro is listed there but gives the same ieror. I will try to instantiate the item object variable. "Sue Mosher [MVP-Outlook]" wrote: Is this code running inside the Outlook form? If not, you need to instantiate an Item object variable somewhere in your code to tell Outlook what item to work with. -- 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 "Francine Otterson" wrote in message ... First thank you for your help - I am making progress and the solution of using the Word template to do what I need does seem to be the best option. But I am once again stuck and after trying for way too long on my own I decided to ask for help. I did check in you book and on the newgroups. I am sure the answer is there but I am missing it. I used the code in Ch 22 as I a guideline but I keep getting variable not defined for the following code. Seems the problem is Item.UserProperities. Sub FillFields(objDoc) Dim colFields Set colFields = objDoc.FormFields colFields("LabManagerName").Result = _ Item.UserProperites("Lab Manager Name") End Sub "Sue Mosher [MVP-Outlook]" wrote: You must add the fields to the folder, either manually or by writing a script or some VBA code that (a) creates a new post in the folder and (b) adds fields to it. Such a script is available at http://www.exchangeadmin.com/article...ticleid=23483; you don't have to register to download the code. "Francine Otterson" wrote in message ... Hi there Sue, thanks so much I will look at it. I am sure with my background in doing this in Access is not helping it seems to be much different in Outlook. At least I know I am just missing something. I do have one more question for you - if I may. I created the form but realized that I did all the customizatio "user-defined" fields at the form level and not folder level. Now when I created a new sub-folder the items that are not on the form are not available under the folder level. Preventing me from adding them to mail-merge. Any way to rectify this easily. "Sue Mosher [MVP-Outlook]" wrote: Hi Francine! It *is* difficult, at least until you understand the technique. Outlook doesn't do WYSIWYG printing of custom forms. I always use the Word template method described at http://www.outlookcode.com/d/customprint.htm along with other various solutions. "Francine Otterson" Francine wrote in message ... Okay all I think I am making this more difficult then it needs to be so I thought instead of doing that I would ask our group here for help. Created customized form with mutliple tabs and fields. I am trying to find the best way to print a customized contact form. The goal is to be able to print the contact form that is selected in a predined tempate automatically by pushing a print command button. Typically they are going to print a single contact at a a time. I am trying to figure out the best method to do this such as create and make it as seemless as possible to the end-user. Francine Otterson MVP - Outlook |
Custom Form Printing
I'm now confused about where you're writing your code. The code behind a custom Outlook form is VBScript, not VBA macros.
-- 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 "Francine Otterson" wrote in message ... Sue, I thought it was running in the form. Well at least when I open the form the macro is listed there but gives the same ieror. I will try to instantiate the item object variable. "Sue Mosher [MVP-Outlook]" wrote: Is this code running inside the Outlook form? If not, you need to instantiate an Item object variable somewhere in your code to tell Outlook what item to work with. "Francine Otterson" wrote in message ... First thank you for your help - I am making progress and the solution of using the Word template to do what I need does seem to be the best option. But I am once again stuck and after trying for way too long on my own I decided to ask for help. I did check in you book and on the newgroups. I am sure the answer is there but I am missing it. I used the code in Ch 22 as I a guideline but I keep getting variable not defined for the following code. Seems the problem is Item.UserProperities. Sub FillFields(objDoc) Dim colFields Set colFields = objDoc.FormFields colFields("LabManagerName").Result = _ Item.UserProperites("Lab Manager Name") End Sub "Sue Mosher [MVP-Outlook]" wrote: You must add the fields to the folder, either manually or by writing a script or some VBA code that (a) creates a new post in the folder and (b) adds fields to it. Such a script is available at http://www.exchangeadmin.com/article...ticleid=23483; you don't have to register to download the code. "Francine Otterson" wrote in message ... Hi there Sue, thanks so much I will look at it. I am sure with my background in doing this in Access is not helping it seems to be much different in Outlook. At least I know I am just missing something. I do have one more question for you - if I may. I created the form but realized that I did all the customizatio "user-defined" fields at the form level and not folder level. Now when I created a new sub-folder the items that are not on the form are not available under the folder level. Preventing me from adding them to mail-merge. Any way to rectify this easily. "Sue Mosher [MVP-Outlook]" wrote: Hi Francine! It *is* difficult, at least until you understand the technique. Outlook doesn't do WYSIWYG printing of custom forms. I always use the Word template method described at http://www.outlookcode.com/d/customprint.htm along with other various solutions. "Francine Otterson" Francine wrote in message ... Okay all I think I am making this more difficult then it needs to be so I thought instead of doing that I would ask our group here for help. Created customized form with mutliple tabs and fields. I am trying to find the best way to print a customized contact form. The goal is to be able to print the contact form that is selected in a predined tempate automatically by pushing a print command button. Typically they are going to print a single contact at a a time. I am trying to figure out the best method to do this such as create and make it as seemless as possible to the end-user. Francine Otterson MVP - Outlook |
Custom Form Printing
I notice you have a typo in " Item.UserProperites("Lab Manager Name") " (
should be " Item.UserProperties("Lab Manager Name") ". It couldn't be as simple as that could it? "Francine Otterson" wrote: First thank you for your help - I am making progress and the solution of using the Word template to do what I need does seem to be the best option. But I am once again stuck and after trying for way too long on my own I decided to ask for help. I did check in you book and on the newgroups. I am sure the answer is there but I am missing it. I used the code in Ch 22 as I a guideline but I keep getting variable not defined for the following code. Seems the problem is Item.UserProperities. Sub FillFields(objDoc) Dim colFields Set colFields = objDoc.FormFields colFields("LabManagerName").Result = _ Item.UserProperites("Lab Manager Name") End Sub "Sue Mosher [MVP-Outlook]" wrote: You must add the fields to the folder, either manually or by writing a script or some VBA code that (a) creates a new post in the folder and (b) adds fields to it. Such a script is available at http://www.exchangeadmin.com/article...ticleid=23483; you don't have to register to download the code. -- 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 "Francine Otterson" wrote in message ... Hi there Sue, thanks so much I will look at it. I am sure with my background in doing this in Access is not helping it seems to be much different in Outlook. At least I know I am just missing something. I do have one more question for you - if I may. I created the form but realized that I did all the customizatio "user-defined" fields at the form level and not folder level. Now when I created a new sub-folder the items that are not on the form are not available under the folder level. Preventing me from adding them to mail-merge. Any way to rectify this easily. "Sue Mosher [MVP-Outlook]" wrote: Hi Francine! It *is* difficult, at least until you understand the technique. Outlook doesn't do WYSIWYG printing of custom forms. I always use the Word template method described at http://www.outlookcode.com/d/customprint.htm along with other various solutions. "Francine Otterson" Francine wrote in message ... Okay all I think I am making this more difficult then it needs to be so I thought instead of doing that I would ask our group here for help. Created customized form with mutliple tabs and fields. I am trying to find the best way to print a customized contact form. The goal is to be able to print the contact form that is selected in a predined tempate automatically by pushing a print command button. Typically they are going to print a single contact at a a time. I am trying to figure out the best method to do this such as create and make it as seemless as possible to the end-user. Francine Otterson MVP - Outlook |
Custom Form Printing
Sue, first thank you for your patience it is in the form itself.
-- Francine Otterson President, San Diego Outlook User Group MVP - Microsoft Outlook "Sue Mosher [MVP-Outlook]" wrote in message ... I'm now confused about where you're writing your code. The code behind a custom Outlook form is VBScript, not VBA macros. -- 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 "Francine Otterson" wrote in message ... Sue, I thought it was running in the form. Well at least when I open the form the macro is listed there but gives the same ieror. I will try to instantiate the item object variable. "Sue Mosher [MVP-Outlook]" wrote: Is this code running inside the Outlook form? If not, you need to instantiate an Item object variable somewhere in your code to tell Outlook what item to work with. "Francine Otterson" wrote in message ... First thank you for your help - I am making progress and the solution of using the Word template to do what I need does seem to be the best option. But I am once again stuck and after trying for way too long on my own I decided to ask for help. I did check in you book and on the newgroups. I am sure the answer is there but I am missing it. I used the code in Ch 22 as I a guideline but I keep getting variable not defined for the following code. Seems the problem is Item.UserProperities. Sub FillFields(objDoc) Dim colFields Set colFields = objDoc.FormFields colFields("LabManagerName").Result = _ Item.UserProperites("Lab Manager Name") End Sub "Sue Mosher [MVP-Outlook]" wrote: You must add the fields to the folder, either manually or by writing a script or some VBA code that (a) creates a new post in the folder and (b) adds fields to it. Such a script is available at http://www.exchangeadmin.com/article...ticleid=23483; you don't have to register to download the code. "Francine Otterson" wrote in message ... Hi there Sue, thanks so much I will look at it. I am sure with my background in doing this in Access is not helping it seems to be much different in Outlook. At least I know I am just missing something. I do have one more question for you - if I may. I created the form but realized that I did all the customizatio "user-defined" fields at the form level and not folder level. Now when I created a new sub-folder the items that are not on the form are not available under the folder level. Preventing me from adding them to mail-merge. Any way to rectify this easily. "Sue Mosher [MVP-Outlook]" wrote: Hi Francine! It *is* difficult, at least until you understand the technique. Outlook doesn't do WYSIWYG printing of custom forms. I always use the Word template method described at http://www.outlookcode.com/d/customprint.htm along with other various solutions. "Francine Otterson" Francine wrote in message ... Okay all I think I am making this more difficult then it needs to be so I thought instead of doing that I would ask our group here for help. Created customized form with mutliple tabs and fields. I am trying to find the best way to print a customized contact form. The goal is to be able to print the contact form that is selected in a predined tempate automatically by pushing a print command button. Typically they are going to print a single contact at a a time. I am trying to figure out the best method to do this such as create and make it as seemless as possible to the end-user. Francine Otterson MVP - Outlook |
All times are GMT +1. The time now is 08:50 PM. |
|
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com