Custom Form Printing

[Guest]

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

 

[Sue Mosher [MVP-Outlook]]

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

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

 

[Guest]

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

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/articles/index.cfm?articleid=23483; you don't have to register to download the code.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

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

 

[Guest]

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

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

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

 

[Guest]

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

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

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

 

[Guest]

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]

Sue, first thank you for your patience it is in the form itself.

--
Francine Otterson
President, San Diego Outlook User Group
MVP - Microsoft Outlook
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

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

 

[Francine Otterson]

Thank you very much - I will check it AGAIN - I must have looked at in a
hundred times and missed that.

Regards-

 

[Guest]

Sue, I think the code below is what I need as I have created a custom from
with User Defined Fields in the Folder which is what I need. However now I
need to move the custom from to another folder. When I publish the form to
the new folder the User Defined Fields are not there once I publish it to the
new folder location. I believe the code listed below would be the option to
take or is there a better way for moving the custom form from one folder to
another without losing the user-defined from fields in the folder, which I
need in order to do to the mail merge -catalog option. Regarding the
script indicated below I looked on the page but I can not seem to locate it.

Appreciate all you do very much

Francine Otterson
Outlook MVP

 

[Sue Mosher [MVP-Outlook]]

Ah, they've rearranged the pages again. Here's the script link: http://www.windowsitpro.com/Files/04/23483/23483.zip

Moving the form, publishing the form, etc. will have no effect on the fields defined in the folder. You must add the fields to each folder if you want to see them in the folder views.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

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