Designing Custom Outlook Forms

Last reviewed on January 24, 2013

One of the great features in Microsoft Outlook is the ability to design custom forms.

Before you can design forms in Microsoft Outlook 2010 or Outlook 2013, you need to enable the Developer ribbon. Go to File, Options, Customize Ribbon and add a check to Developer

Enable Developer ribbon in Outlook 2010

In Outlook 2007 you need to enable the Developer ribbon for Outlook items (mail, calendar, contact forms, etc) from the Office Icon, Editor options dialog. You can also open the Forms Designer as you would for all older versions: using Outlook's Tools, Forms menu.

Enable Outlook 2007 Developer Ribbon

Video Tutorial: Enable the Developer Ribbon

Open a form in the Forms Designer

Once you have the Developer ribbon enabled, you can open a new Outlook item (of the type you want to design) then choose Developer ribbon, Design this form and the form opens in design mode. Any content already in the Outlook item will be carried over into the form.

If you prefer, you choose Design a Form and browse for the form type you want to design.

Design and Publish commands on the Developer ribbon

In Outlook 2007 and older, you can open forms from the Tools | Forms menu, choosing Design a Form when in the main Outlook window.

In Outlook 2003 and older, you can also use the Tools | Forms | Design this form command in an opened item.

Creating different read and compose pages

Outlook supports separate read and compose pages. Check the settings under the Page options and if you are using a separate read layout, you’ll need to Edit the Read Page too.

Check the settings for separate read page

Save as a template or publish the from?

When you are finished editing your form, Publish the form or save it in Windows file system as a template (*.oft).

If the form contains VB Script, you’ll definitely need to publish it.

The screenshot below is of the Contacts form in design mode. Note that the Contact form looks like the old Outlook 2002 (and older) forms. As long as you don't edit the first page, it will retain the look of Microsoft Outlook 2003 Contact forms and up when published.

Design Mode

Written by

Diane Poremsky
A Microsoft Outlook Most Valuable Professional (MVP) since 1999, Diane is the author of several books, including Outlook 2013 Absolute Beginners Book. She also created video training CDs and online training classes for Microsoft Outlook. You can find her helping people online in Outlook Forums as well as in the Microsoft Answers and TechNet forums.

Please post long or more complicated questions at Outlookforums.

245 responses to “Designing Custom Outlook Forms”

  1. Darlette Drummond

    I have created a custom form in Outlook 2010 and when the form is sent the fields are invisible.

  2. rumbidzai

    Am having the same problem with Darlette when i send the email the fields are invisible.Any solution to this

  3. Mike

    Outlook 2007 (SP3), and are experiencing a problem with the Message field. When the form is completed and sent from one user to the next, the Message Field does not retain any of the contents (signature, custom message, etc.) that the author added. Other times, it will retain the information, but will "drop" the contents after the form has been Replied To or Forwarded several times. It is very intermittent. Please let me know if you have any thoughts on what could be causing this. The form design was not changed at all during the conversion from 2003 to 2007, and the problem never existed while using 2003. Thank you.

  4. johnorcutt

    Sue:

    I am a lawyer. I need to send email confirmations to clients of upcoming appointments.
    Can I use custom "message" forms for this purpose? I am using Outlook 2007. I ask because I read something where you indicated that custom forms could only be sent to "internal" users. I need to send these emails to "external" users. If I can't use custom forms for the purpose, what do you suggest? The only thing I can think of is to cut and paste the message into each new email on a standard email form, and then edit the form to put in the correct date and time for the appointment, which seems archaic to me. Thanks so much. John Orcutt

  5. jim

    How can you add a URL field in a Outlook Custom Contact form?

    I have been googling everything. Is this even possible? Just a simple field for a url other than the default Webpage field. I am at a complete loss and a little embarrassed that i can't figure it out. Thanks for any help!

  6. Louise

    If I add date fields into a contact form, how do these link with my calendar? I would like to add review dates to my contacts and have these dates place automatically in my Calendar.

  7. Matt

    Hi Diane - thanks that (blankness) was also my problem and your solution was spot on.

    I'd like the read page to look the same as the form but when I uncheck "Seperate Read Layout" it doesn't seem to happen. If I cant make the form appear on the read page, how do I edit it?

    Thanks in advance!.

  8. Paulette English

    I have four yes/no check boxes in my form. When I check one, they all check. How do I prevent this?

  9. Ian S.

    Hi Diane,

    We have had a custom TaskItem in a global folder, which has been used on outlook 2003 on XP for some time. We are upgrading to Win7, and I am trying to ensure the forms work with the newer outlook.

    We have a Note item that is created, and then a view script which convers it to a task when assigned. Problem is, the custome event handler for item_Open that should run, doesn't seem to be.

    But, if I go into the develop mode of that task item before it is saved, and click on run the form, it works as intended. Have you heard of something like this? The script runs an item.Display, and it comes up, but the item_open function doesn't seem to run (to be more clear)

    Any assistance would be great, I'm figuring I'll have to go to msdn about this though :S

    Thanks!

  10. Kristen

    Hi Diane,

    I have made a custom Task form for my users to add and edit Tasks. However, they cannot format the text in the body. The text formatting controls available on the default Task form are disabled in the custom form. How can I make it possible for them to format their body of their Tasks?

    Thanks so much in advance! Any help is greatly appreciated.

  11. Kristen

    That did the trick! Thank you for your help!

  12. Melanie

    Hi Diane,

    Can I get Outlook to send me an email notification when someone in my office fills out a form for me? Thanks for your help!

  13. Melanie

    It's a custom task request form. I inherited it, so unfortunately I haven't been through the process of setting such a form up from scratch.

  14. Mark

    Hello Diane. We have a form published on our Exchange 2010 public folder that allows us to book conference rooms on a calendar. The form works well for everyone except one particular user from her specific PC (Outlook 2010). If I log in as her from our Citrix server she does not have an issue with the form. So, the issue seems specific to her PC. The form she gets while logged in from her PC somehow seems corrupted as it does not behave properly. My guess is that she somehow managed to get a version of the form that everyone else gets from the public folder, but she has a corrupted version of the form save in one of her personal form locations. Do you have any information you can send me that will allow me to identify the corrupted form she might be getting and how to remove it. How can I check the various locations where this form might be saved and remove the corrupted form. Thanks, Mark

  15. ron

    Currently, when the user replies to the form, you only see the following info in the reply-header:

    From: Doe, John
    Sent: Tuesday, March 26, 2013 1:47 PM
    To: Smith, Jane
    Subject: asdf

    message/body of email.

    How to I get a custom form field (e.g Study ID) to show up in the reply header when the recipient replies to the email so it looks like this:

    From: Doe, John
    Sent: Tuesday, March 26, 2013 1:47 PM
    To: Smith, Jane
    Subject: asdf
    Study ID: Study 123

  16. ron

    Yes. Its Outllok 2003 exchange

  17. ron

    The Study ID is its own field and follows after the subject.

  18. ron

    Thanks Diane. Still can't get it to work. Can you post the script that I should copy and paste if it's not too much to ask?

  19. Shveta

    Hi Diane,

    I designed a form with same Edit Compose Page and Edit Read Page in Outlook 2007. I ran the form, entered some data in the fields and sent to myself for testing. Opening the form from my Inbox does not contain any of the contents that I entered while sending.

    Could you please let me know the cause?

    Thanks
    Shveta

  20. Cecelia Varela

    Hi Diane,
    I created a custom Outlook form and when it is filled in and sent, the receiver cannot see the information that was entered into the fields. Is there something I need to do to display the information entered into the fields from the sender when the receiver reads the email?

  21. Abhay

    Hi
    I have saved an email template .ost file in template folder. When I create an email using the template and send it, it gets received correctly. However, I can not trace it back in my Sent Items folder like any other emails.
    I want to know where to search for these emails if not in Sent Items.

  22. Joseph

    Hello,
    Thank you for your helpful guidance! I am trying to recreate the % Complete field with the horizontal and vertical arrows to cycle through the %0 %25 ect. as well as make a status drop down with diffrent selections in it. How do you go about doing this? It would also be great to be able to duplicate the Start date drop down into a calandar.
    Thanks for your help!

  23. Laura

    Hi Diane,

    I have created an Custom Form in Outlook 2007. When the form is completed and sent from one user to the next, the Message Field does not retain any of the contents that was added initially.

    Only the message page is set to be displayed and the 'Separate Read Layout' is not checked. All the custom fields I have added are displayed ok with the initial content, its just the message that is completely blank.
    Please can you advise why this is happening?

  24. Laura

    Hi,
    Thanks fo rthe quick reply.

    I have tried various things. I have run from the code/design option and I have published to the Personal Forms Library.

    I have also created FDM files from the published forms.

    I thought sending the form definiotn with the form was not recommended and that the code I have writen would not run?

  25. Laura

    Yes, I have code (VBScript using the Script Editor). I have code written for Comboboxes, listBoxes etc. I publish the form, then select the form, fill in the details. All the parts I have added code to are present in the recipients emaail, but the message is completely blank.

  26. Laura

    Yes, I have VBScript (via the Script Editor) - it autopopulates some textboxes, list boxes etc and manipulates others. The custom fields are all showing correctly in the recipients email, but the message is completely blank.

    Does the P2 tab have anything to do with it?

  27. Richard

    Hi,
    We have several custom forms designed in Outlook 2000 and 2003. After we switched to Outlook 2010 we started having problems with the custom forms.
    Forms are published on an Exchange 2003 server.

    Problem 1:
    In Outlook 2010 you receive a custom form (designed in Outlook 2000/2003). This looks fine but when you save it as a file (.msg) and later re-open it, you just get a blank email message.
    However, when opening the same file in Outlook 2003 you see the custom form with all entered fields again.
    We use this as the files are save as an attachment in another program.
    Any ideas?

    Problem 2:
    We have one custom form that also use the form layout on reply or forward.
    So I open the form, fill in the required fields and send it to a collegue. He/she goes to work and fills in some more fields and sent the custom form back.
    When I receive the form back, the additional fields my collegue entered are empy. Also the default message field is empty.
    When my colleague opens the form from sent items, the additional fields are also empty.
    Sometimes Outlook just crashed when sending this form. The form contained some piece of VB code but that is already disabled.
    We don’t use a separate read layout for this form.
    The option ‘send form definition’ is enabled.
    Any thought about this? These problems did not occur with Outlook 2003.

  28. Steven Jones

    Hi,
    I made a Outlook 2010 custom task form using vba which generates an email when the task is marked as "completed".

    When I try to select the task from the to do list, the task appears as an ordinary task and not my custom one, hence the email is not generated. I have to be in the tasks list to get it to work properly. Any ideas?

  29. Steven Jones

    I had originally published it to "outlook folders". I will try your suggestion - it seems to be working (but so did my original!) Is there a way to put a shortcut to these forms to make them easier to navigate to? With my previous published location, if I was in "tasks" the form appeared on the drop down menu under custom forms.

  30. Steven Jones

    Thanks Diane.
    Lastly, the custom task seems to be stored in the wrong folder - inbox rather than tasks - how do I put this right?

  31. Leslie

    I created a custom form per the instructions and published it to my personal forms library. When I test it and send it off to another account which I have full access permission to or even if sending to myself, the bound fields I added do not show up on the form. I have tried editing a message template and adding a second page to the meeting template. The meeting template (when opened from my computer) after it is sent gives the warning message "To help prevent malicious code from running, one or more objects in this form were not loaded. For more information, contact your administrator" when I try to open the customized second page. I have checked all the settings in the Trust Center. What am I missing here? This seems like such a simple process yet I cannot make it work!

  32. reem

    Hi,
    I have designed a custom form , in this form i used a textbox which is used for call number , i need it to increase serially automatically
    after i open the form and not to return the initial value.
    please help me .

  33. reem

    Hi Diane,
    THanks very much for your replay, but I do not know how
    to do it .

  34. reem

    Thanks alot Diane for your helping
    But when I close the form and open it again ,the textbox value return to the initial value which is 1 ,and I do not want this , I want to show the last serial number .
    Thanks in advance.

  35. reem

    I mean when I re-open it from tools-forms-myform

  36. Carmen

    Hello Diane,
    I want to increment the value of textbox everytime the p.2 loads ,
    so if i load the page the textbox value will be 1 ,the second time 2 and so on ,and if it possible that the value will be saved after i close the outlook ??

  37. reem

    Thanks ,
    But I faced aproblem when I wrote VBA code in outlook ,that I can not access the textbox which i used in custom form to change its value , any idea?

  38. reem

    Thanks Diane very much ,I appreciate your help .

  39. Sara

    Hi,
    I have a few questions about my custom template that I am creating in Outlook 2010. First, how can I add fields into the message box such as check mark boxes (attachment). Along with that when I use the standard message template, the message field box has stuff written in it that I would like to get rid of but I cannot click around in there at all. My second question is that I tried to use a template that someone in my office had used but even once I edit it to fit my information and send a test email, the email will send to me but will be blank and have the original ladies information written on the bottom of the blank email. Any ideas what I can do?

    Thanks!

  40. akil

    Hi,
    I have some questions regarding the using of outlook custom form.
    1) when I receive a meeting request or an appointment request, is it possible to automatically switch from the basic outlook calendar form to my calendar custom form ?
    2) My custom form has 2 pages. I was wondering how to hide the second page. But it seems that I only need to use the "Separate read layout". Is it correct ?

    Thanks for your responses.

    Akil.

  41. Ivan

    As my first venture into VBscript programming I decided to create a custom Task in Outlook 2010. My PC resides on a very large network. It seemed quite easy, I followed your guide and quickly had a rough custom task up and running but with flaws. Basically I wanted to open a new task, have a dialogue with the user then populate the task with some fixed information, the info changes depending upon the dialogue. Things became tricky when I tried to catch all the variations a user might enter in an input box e.g. Opens Task but then decides to cancel rather than progress the action. I have used the Item_Open event to drive the process and I have muddled through and learned quite well but ideally would like to prevent the Custom task being displayed if the user 'cancels' at the InputBox (dialogue) stage and thus the task is not created. After several hard hours on the web I still don't have a solution. To make things easier (read as harder)I initially developed my input routine in a standalone.VBS file and used WScript.Quit at the relevent point in the routine. All worked perfectly till I merged my populate task routine with the revised input routine i.e. I added code to my simple custom Outlook task. The WScript.Quit did not work, everywhere on the web people suggest using this and possibly it maybe because of the security policies related to my PC. Anyway I worked round that by adding a flag in my code to indicate the user had clicked cancel. The last issue is to close the pending Custom task i.e. destroy it before it shows. I've tried all variations of Item.Close, CurrentTask.Close, TaskItem.Close and many many more to no avail. Is there a solution ?
    VBScript looked promising initially but soon shows its limitations with regard to user dialogue and the script editor and I guess my inexperience does not help. Thanks

  42. Brandon

    Diane - I am attempting to make a custom email form that can be sent from and to different Outlook users. I made the form, which basically includes a several fields (date, job#, work center, etc) that are to be filled in by the sender. Once I send the message, the recipient is not able to see the fields. What am I doing wrong?

  43. Brandon

    I have now checked the box on the properties page that says "send form definitions." However, when I tried to email the form, the text boxes and controls still did not show up in either my sent items or in the recipient's inbox. Any other ideas?

    Thanks

  44. Paul Lehman

    Great information/resource here!

    Diane - I would like to know if a customized contact form can be tied to a category. Simply looking to use a contact form that has additional fields specifically for client contacts.
    Can the custom form be triggered by a category?
    Thanks!

  45. Ivan

    I've cracked it:- The item_open event is a function and is able to return either True or False to Outlook. Thus if the user selects CANCEL at the dialogue stage code can return FALSE and Outlook will not open the task. In the Task Open event I have called a HTA to perfrom the dialgoue with the user. To pass the user data back to the VBS in the task, the HTA writes to a local file then the HTA closes. The VBS in the Task continues by reading the data in the local file and populates the task with the relevant text.

  46. Gabrielle

    Thank you, Diane for all the replies you provide and help. I've referred to your expertise often!

    However I now need some help and know that you've replied on this previously, but not completely.

    As a busy real estate agent, I need to track dates of transaction closings and that sort of thing. I've created a custom form with custom fields such as "closed on," but need that information to populate either to the calendar or to a task so that I can follow up with previous clients on important dates. I'm definitely not a VBA programmer and haven't a clue how to accomplish this. Can this be done at all?

    Thank you!!

  47. Erum

    Hi Diane,

    I made my very first form using your article. It just has a few labels and text boxes. But when i run it ,fill the fields and send it (i have send the form definition check box ON and i dont have a separate Read layout ) , the reciever gets a totally blank message.l Nothing shows - neither the labels nor what i entered in the fields. Any idea what I am ding wrong?

    I want to make this form for myself only - to help me compose a certain email and i would be sending out to external people as well

    Thanks
    Erum.

  48. Ivan

    Does anyone have problems with the VBS editor in Outlook 2010. I'm finding that characters disappear from my script occasionally and in the same place. If I delete a couple of empty lines other characters then disappear. Simply running my custom Task produces these effects. I then have to reinstate the missing characters then republish the Task. Apart from this my custom form works perfectly.
    ???????

  49. Jaco

    Dear Diane,

    We have an exchange 2010 environment and build a custom form for outlook invites in our functional mailbox. When you open a new invite, you can click on an icon in the Ribbon and fill in the extra fields.

    When sent to others in the company, some of them can see this button, but most cannot. Any idea what could be wrong ?

    Kind Regards

  50. Adam Mitchell

    Hi Diane,
    I've been having a very similar issue as many who have been posting.
    We are currently using Outlook 2007. All custom forms that I have designed appear blank (as in, none of the fields I defined are there) when I send them to anyone--including myself.
    I have unchecked "Separate Read Layout" so I am only designing for one layout. I have checked "Send Form Definition with Item", and I get nothing.
    I've made sure all my controls are linked to fields, so that should be ok. I've tried changing the format that the email sends in, and that doesn't seem to do anything either.

    What I'm trying to do is create a trouble ticket form that has two combobox controls. One has a list of possible categories a user could be having, the other has a list of different degrees of impact with their issue. I've created the comboboxes fine and they actually look pretty nice :) but they don't appear when I send them to anyone.

    Any thoughts?

    Thank you very much,
    Adam

  51. petee

    Hi,
    I have a custom form with two pages. I would like to create validation formula for one of my controls. This control should depend on it's own state/value and on value of other control which is located on other page.
    It seems that controls only from current page are available (or I don't know how to refer to control located on other page).

    Example:
    P.1 -> Control "text"
    P2. -> Control "checkbox"

    Validation formula for checkbox - text must be set to "male", then checkbox must be ticked:
    = "male" AND [checkbox] = true
    But there is an error: Error in validation formula for "checkbox" -- unknown field.

    Is it possible to use controls from different pages for validation formula?

    Regards!

  52. petee

    Yes, checkbox is used as control name. And because field names are used in validation formulas, also as field name.

    Looks like I found workaround. I copied control from P.1 to P.2. Also field of this control was copied and value of this field changes on both pages at the same time.
    What is good - right now I can refer to this field also in validation formula on P.2. So I broke some boundaries :-)
    Finally I set control on P.2 as not visible and now my validation formula works as a charm.

    Regards!

  53. Kris

    Hello, I have created a large custom form, but it has so many fields, that I would like to break it up into two different task lists. Is there a way to have: Form 1 (with a ton of fields, say 1-200) and then to have two task lists that display those fields) Task List 1 (fields 1-100) and Task List 2 (fields 101-200) -- I really want all of my info on the one form, but want to track dates, etc on the Task Lists. Clear as mud? What a mess! Thank you for your help!!

  54. Deanna

    Hi, I'm having some issues with a custom meeting form (Outlook 2013) and am unsure if it is even the best solution. It has 4 checkboxes and 2 textboxes; 1 chkbox generates a msgbox to remind users of which conf rm to use and the other chkboxes add recipients to the meeting. These internal users need to see the chkbox values so that they know if they are to supply lunch to guests, etc. but external users do not need to see that info. I can only get code to run if chkbox are not bound to fields, which causes chkboxes to be blank for recipients. Recipients also get a msg that not all objects are loaded to prevent malicious code. I'm assuming this is a publishing issue and am unsure how to publish to entire org in 2013, but realize that I cannot publish this to external users who may be copied on mtg.
    So my question is, what can be done to allow external users to not get that msgbox/only see standard meeting form? I know there are many issues listed, but at the most basic level just am curious if a custom form is best solution to this issue.

  55. Maria Michael

    Hi Diane. I've created a simple form in Outook 2007, unchecked the 'seperate read layout'box and it works if you've got 2007 installed but on 2003 none of the form displays. Could help please?

  56. Wendy

    Hi Diane,
    I am creating an Outlook form to have anyone be able to fill out with in the email and send back. Version is 2013. I see the form then email it and it only shows my signature and not the form itself. I tried separate read layout and it does nothing. It is a fill in the blank and drop down menu type of form. Why is this so complicated? I tried even creating the drop down word and putting it with in the email but when you send it the ability to use the drop down goes away. Help! This would be a great tool to have and I want it. I am so close yet so far away.

  57. Jeroen

    I have the seem issue... Each bugfix results in 2 or more errors on other places in my code... :-(

  58. Jon Biddell

    Weird Outlook forms issue - hoping some of the gurus present might know of a fix.

    We run a mix of 2003/2007 (do NOT get me started !!) and on SOME machines Forms will not work. You select the form from Tools->Forms->Choose a Form, it gets copied to the FORMS folder locally, and then you get an error that it can't be opened.

    Deleted the FORMS folder, etc - makes no difference.
    Compared working and non-working machines for perms, etc - no difference.

    Tearing out what little hair I have left.

  59. Jon Biddell

    Yes, all set appropriately.

    Resolved the issue, but I don't know WHY, by renaming the user's network profile, adding the ForceFormReload key and THEN rebooting.

    Waiting for the next one so I can do some more diagnostics...

  60. Jeremy Diaz

    Diane,
    I am having a problem with forms defaulting to Rich Text even though I create them and publish them using an HTML outlook window. It says HTML on top top bar when I'm creating it, but after I publish it into the Organizational forms library and then open it from there it opens as rich text. Do you know how I can fix this? Running Outlook 2007 and Exchange 2013. Thanks for your help!

  61. Jeremy Diaz

    I'm wondering why my question wasn't approved. I noticed it was pending and not it's gone.

  62. Jeremy Diaz

    Sorry Diane, I didn't see it in the list. Okay, no worries. If I can provide any other details let me know. Have a nice day!

  63. Jeremy Diaz

    I'm only using text. It's basically just an email template with blank spaces to fill in.

  64. Jeremy Diaz

    I feel like it has something to do with Exchange 2013. I just found out one of our other offices has the same problem. Maybe there is a setting that we don't have correctly or maybe it's done like that for a reason.

  65. Darren Baker

    Hi Diane

    I have read all the posts above which has helped me a lot, i have one question
    i have placed a message field in my custom form, that also picks up the users email signature, how do i get the form to reset when i publish, as at the moment i have several signatures in it, when i have been testing >

  66. Gurmeet

    hello. I have designed a form in "message" and published in personal Form Library. Now when I am sending the message even to myself, I am not able to see p2 (Pages designed) and the same problems are being faced by my colleagues, I have "checked" the "Display this page" and "separate read layout". Please help

  67. rani

    Outlook 2010-I have a custom form for contacts with 5 'checkbox' fields. When viewing the contacts in a list view, all but one field display a box with a checkmark inside. But one displays 'On' in the column instead of the checkbox. I've double checked all of the properties for these fields but must be missing something. What an I doing wrong?

  68. Nikolay

    I am trying to create a form in Outlook, which collects data from fields and is then inserted in the message body and To field.
    For example
    Name: Nikolay
    Email: nikolay.test@test.com
    Date of call: 11.01.14
    Message body: Hello Nikolay, Thank you for contacting us on 11.01.14. We will get back to you as soon as possible.

    Is there a specific way to capture the fields with VBA code and generate predefined message with the data?

  69. Jeremy Diaz

    Hey Diane! Hope your holidays were good. I never heard back from you after I sent you our email template. At the same time, I'm not sure the template has anything to do with it though. Like I said in the email it could be a blank template and still do the same thing. I wonder if you polled your other exchange 2013 admins if they were seeing the same thing.

  70. Tina Barker

    I have created a form in developer asigned it to my calendar, what i would like is the information on the form to be included in the at a glace calendar view is this possiable ?

  71. Kathy Genakos

    I'm trying to post a question for Diane. I have MS Office Professional Plus 2010 with Outlook v14. I am teaching myself how to create a custom message form in Outlook. It is currently saved to my Personal Forms Library (while developing). When I make a change and publish then save, a new .tmp file is created and the ending of the IPM.Note.xxx has numbers added (e.g. 000, 001). I have a hyperlink in an Excel form that launches the custom msg form because I chg the .tmp to .msg and associate the Outlook.exe file. I have to edit the hyperlink info in Excel after I save/publish a change to the custom mgs form. Is that only happening because I'm using my Personal Library? Also, because I'm associating the Outlook.exe file, the Excel hyperlink is launching Outlook and then automatically defaults to the custom msg form. Is ther some other way I should be able to open the custom msg form within an already open instance of Outlook? Finally, how can I have the "From" field auto-populated with each various sender's default email address?

  72. Kathy Genakos

    Diane, I have a hyperlink in Excel form setup to launch my custom form. I'm still developing the custom form so it's saved to my Personal Library. Everytime I make a change, a new .tmp file is saved which I then have to rename to .msg to associate the Outlook.exe and then update the hyperlink in the Excel form. THEN...I have to close Outlook in order for the hyperlink to open Outlook and auto-display my custom form. Any suggestions for eliminating all this manual effort?

  73. Kathy Genakos

    Thanks so much for your prompt response! I'll ask my company's IT people to look into why it it's saving to my C-drive as a .tmp vs. a .oft

  74. Kathy Genakos

    I'm wondering if you know what the underlying file path is when accessing the IPM.Note."display name" from Outlook/New Items/More Items/Choose Form/"Look in": Personal Forms Library/No Category Name/No Subcategory Name Also, is IPM.Note the correct message class for a custom email message? (I created my custom email message based on our company's standard email message).

  75. Kathy Genakos

    Sorry about the double-post on my last reply. My screen hadn't refreshed so I couldn't be sure my first attempt worked. I have another question... In Outlook/Options/Advanced/Developers "Custom Forms" button which launches the Option Window, What does the checkbox to "Allow forms that bypass Outlook" enable? Still trying to figure out how to get my Excel hyperlink to launch my custom email form so I'm looking for anything that might get me to that end.

  76. Kathy Genakos

    If I save my custom form to the Organizational Forms Library, should it still have a .oft extension? If not, what extension would it be automatically set to?

  77. Kathy Genakos

    I've never created or used an Excel macro. I copy/pasted the code from the above mentioned article by clicking Excel's Macro icon in the workbook that has my Excel Form, giving the macro a name (i.e. HRMCR) and clicking the Create button. I got an err msg: the following features cannot be saved in macro-free workbooks: VB Project. To save a file with these features, click No, and then choose a macro-enabled file type in the file type list. To continue saving as a macro-free workbook, click Yes.

  78. Kathy Genakos

    I copy/pasted the macro from the recommended article but it's giving me a compile error:

    (NOTE: I was prompted to create a macro name so I called it HRMCR. I opened the path on my C-drive to the IPM.Note.TEST ONLY - DO NOT USE - HR Mass Change Request folder as my currently active folder.)

    Sub HRMCR()
    Public Sub OpenPublishedForm()
    Dim Items As Outlook.Items (It's saying compile error. User-defined type not defined.)
    Dim Item As Object
    Set Items = Application.ActiveExplorer.CurrentFolder.Items
    Set Item = Items.Add("ipm.note.TEST ONLY - DO NOT USE - HR Mass Change Request")
    Item.Display End Sub

    End Sub

  79. Kathy Genakos

    Just realized that Visual Basic has the ability to create forms in Excel. My Excel "form" is not a Visual Basic form. It's just a worksheet with drop-down values and enterable fields. It currently has a hyperlink that opens the standard Outlook email msg. The person completing the Excel worksheet saves the worksheet (whereever) and attaches it to the standard Outlook email msg. The only thing that's changing is we need for them to launch the custom email msg to attach their completed and saved Excel worksheet to.

  80. Kathy Genakos

    The compile error is gone by modifying the code from the article with the code you provided. I made modifications where I thought they should go (I have zero experience with Custom Forms in Outlook and zero experience with Macros in Excel)

    Private Sub OpenPublishedForm()
    Dim myOlApp As Outlook.Application
    Dim Items As Outlook.Items
    Dim Item As Outlook.MailItem
    Dim Item As Object
    Set myOlApp = CreateObject("Outlook.Application")
    Set Items = myOlApp.ActiveExplorer.CurrentFolder.Items
    Set Item = Items.Add("ipm.note.TEST ONLY - DO NOT USE - HR Mass Change Request")
    Item.Display
    Set Item = Nothing
    Set myOlApp = Nothing
    End Sub
    End Sub

    Sub HRMCR()

    End Sub

    When I "run" the macro, nothing happens. What I'm hoping for is that my custom Outlook form will open.

    You're so amazing! (No kidding) I'm sure you'll be able to explain how I can make that happen.

  81. Kathy Genakos

    Diane: I found VB code on the Internet that is working but launching the standard Outlook email message. Would you know how I would modify the code to have my custom email message launch?

    Sub Mail_Workbook_1()
    ' Works in Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Outlook 2000, Outlook 2002, Outlook 2003, Outlook 2007, Outlook 2010.
    ' This example sends the last saved version of the Activeworkbook object .
    Dim OutApp As Object
    Dim OutMail As Object

    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)

    On Error Resume Next
    ' Change the mail address and subject in the macro before you run it.
    With OutMail
    .To = "kathy.genakos@sanofi.com"
    .CC = ""
    .BCC = ""
    .Subject = "HR_Mass_Change_Request"
    .Body = "Hello World!"
    .Attachments.Add ActiveWorkbook.FullName
    ' You can add other files by uncommenting the following line.
    '.Attachments.Add ("C:\test.txt")
    ' In place of the following statement, you can use ".Display" to
    ' display the mail.
    '.Send
    .Display
    End With
    On Error GoTo 0

    Set OutMail = Nothing
    Set OutApp = Nothing
    End Sub

  82. Kathy Genakos

    Woo Hoo!! I got the custom email form thanks to your advice above! I'm still working in the Personal Forms Library pending access to the Organziational. Next issue...I enter stuff into the Excel form/worksheet, do a save as, rename the worksheet, click the button I created with the associated macro but it doesn't launch the macro on the first click. I first have to click anywhere else in the Saved As Excel & renamed worksheet THEN the macro button launches the custom email form with the Saved As Excel file attached. Thoughts?

  83. Kathy Genakos

    Oops! Sorry on closer inspection the modified code did NOT launch my custom email form...but I think that's because the form is not available in the Organizational Forms Library...until my company grants me rights to that Library. Do you think that would that resolve my macro button issue?

  84. Kathy Genakos

    The macro with the modification you recommended IS working from my Personal Forms Library (opening the custom email form) when I have the folder path open to the ipm.note.TEST ONLY - DO NOT USE - HR Mass Change Request folder. So I "think" it should work once the custom email form is posted to the Organizational Forms Library. (I'd keep my fingers crossed but then I wouldn't be able to type!) Still wondering why I have to click somewhere on the saved Excel form/worksheet before I can click on the macro button to run the macro. Any suggestions?

  85. Kathy Genakos

    I put the macro in my active Excel workbook. That Excel workbook is currently saved to my C-drive. However, the custom email form is in my Personal Forms Library in Outlook so that's where the ipm.note.TEST ONLY - DO NOT USE - HR Mass Change Request folder is. Once I have access to our Organizational Forms Library, the ipm.note.TEST ONLY - DO NOT USE - HR Mass Change Request folder will be placed there.

  86. Kathy Genakos

    I've removed all of my IPM.Note. test files from my Personal Forms Library. There is now only one IPM.Note. document posted to the Organizational Forms Library. When I try to launch the custom email form via my Excel macro (using the macro button I created) I keep getting the standard email form NOT my custom email form. Is that because I'm trying to send it to myself? Below is the macro within Excel. Any suggestions would be most appreciated!

    Sub Mail_Workbook_1()
    ' Works in Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Outlook 2000, Outlook 2002, Outlook 2003, Outlook 2007, Outlook 2010.
    ' This example sends the last saved version of the Activeworkbook object .
    Dim OutApp As Object
    Dim OutMail As Object

    Set OutApp = CreateObject("Outlook.Application")
    Set Items = OutApp.ActiveExplorer.CurrentFolder.Items
    Set OutMail = Items.Add("IPM.Note.TEST - US HRBP ONLY - HR Mass Change Request")

    On Error Resume Next
    ' Change the mail address and subject in the macro before you run it.
    With OutMail
    .To = "kathy.genakos@sanofi.com"
    .CC = ""
    .BCC = ""
    .Subject = "HR_Mass_Change_Request"
    .Body = ""
    .Attachments.Add ActiveWorkbook.FullName
    ' You can add other files by uncommenting the following line.
    '.Attachments.Add ("C:\test.txt")
    ' In place of the following statement, you can use ".Display" to
    ' display the mail.
    '.Send
    .Display
    End With
    On Error GoTo 0

    Set OutMail = Nothing
    Set OutApp = Nothing
    End Sub

  87. Kathy Genakos

    Diane, Thank you sooooo much!!! I can now pull up my custom email form the Organizational Forms Library FOR THE FIRST TIME EVER!!! I've asked my boss to test if she can see the custom email form from the Excel macro as well. We're off on Monday, so that will have to wait 'til Tuesday. Would you know what the VB code would be to not allow the sender of the custom email to receive it in their Sent Items email folder? I don't want the sender to be able to open the custom form from their Sent Items folder and Reply, Reply All, Resend the Message, Edit Message...etc. No way I could have done any of this without you. A million (and one) THANKS!

  88. Kathy Genakos

    Oh...one more question...(if you had a dime for everytime you heard THAT phrase,huh? LOL)...Would you know what the VB code in Excel would be to auto attach an second file to the macro-generated out-going custom email message? If not, would you be able to recommend an Excel MVP who might know that code?

  89. Kathy Genakos

    First, I'll add the .DeleteAfterSubmit = True statement. (THANKS!) Second, I was going to have the submitters use the same filepath and filename by saving the file to their desktop. I was using the .Attachment.Add c:\filename.ext statement but was including backslashes and asteriks for wildcards where the filepath to the submitter's desktop would include their UserID and therefore be an unknown variable (I wouldn't know how to code for that.) Is it possible to include a filepath resulting in the filename? Perhaps replacing backslashes in the filepath with periods? Here's what I had tried that wasn't working:

    .Attachment.Add ("C:\Users\*\Desktop\MCSS.xls*")

  90. Kathy Genakos

    THANKS, again and again...and AGAIN! I tested the .DeleteAfterSubmit = True statement and it appears to have worked (at least my custom email did not show up in my Sent Items Outlook folder. My boss will test on Tuesday. I'll try the code you recommend and read the link. I've come A VERY LONG WAY in 9 days for someone who knows NOTHING about VB or custom email forms!! Thanks to "YOU"!

  91. Kathy Genakos

    It's working!! YEAH!!! This is exactly what my boss wanted!!

    Funny when I looked at your code in my Outlook preview window I don't see the backslashes around the word Desktop. I copy/pasted it from my Outlook preview window into the bottom of my VB code; then cut/paste it the statements belonged.

    Good thing I fully opened your email or I wouldn't have seen why my code didn't work initially.

    I noticed I had to include the filename's full extension. In my test case that's .xlsx

    We'll have to include in our instructions to the submitters to save their file to their Desktop and call it "MCSS.xlsx" otherwise the code won't auto-send it.

    I prayed for a solution to this business problem and God sent me YOU! I will be forever grateful!

    Let's see how my bosses test goes on Tuesday.

  92. Kathy Genakos

    Thanks for the tip. It's Sunday where I am. Supposed to be a day off but I get so excited to complete the task and learn more I've been at all day. Time to unplug! Hope you get a chance to rest & relax a bit too. Take Care, Kathy

  93. Kathy Genakos

    Hi Diane: My boss tested the Excel file with the VBA to launch the custom email. It went very well! She asked if it is possible to include a statement with the date and time the email was auto-sent in the worksheet containing the macro? Something like: "Thank you. Your email has been submitted. 2014-02-18 at 11:24am" I suppose adding EST time would be helpful but hopefully date & time would be enough. If you know of how I could do this that would be great! BTW I changed my submit button to an ActiveX Control. Now a single click launches the macro; the previous button first needed the user to click any other cell in worksheet THEN the submit button.

  94. Mohammed Hashim

    Hi, I just designed a form and unable to attachment is not working and also i deleted old forms i designed but in print preview is showing the old form and new form format is not available only the values. before i am sending the new form but sending the old one when i disable the separate layout its working with new form. please tell me how to solve these issue. i am beginer

  95. Mohammed Hashim

    Thanks for the help and now it is working fine one thing if i publish in outlook folder then sometimes its not working properly

    Thank you

  96. Kathy Genakos

    Hi, Diane: Thanks to your help, I am able to have the day/date/time added to the Excel form when the ActiveX button is clicked! I used:

    Range("A35").Value = Format(Now, "dddd, mm/dd/yyyy at hh:mm AM/PM") which results in: Monday, 02/24/2014 at 10:43 AM

    Since I'm emailing to Outlook from Excel, I noticed today if Outlook isn't already open, I get the following Microsoft Visual Basic window error msg: "Run-time error '91': Object variable or With block variable not set"

    Would you know what I need to put into Excel's VBA to check if Outlook is open and if not, how to launch it for the user to logon?

    Thanks, Kathy

  97. Kathy Genakos

    Hi, Diane:

    So far the only statement that launched Outlook when Outlook was closed was:

    Application.ActivateMicrosoftApp x1MicrosoftMail

    but then my ActiveX button gets a run-time error msg and I don't know if the above statement would auto-launch a second instance of Outlook if the user is already logged on.

    Is If Err "=" 0 Then?
    Is that a zero one App in the Get and Create statements?
    Also, do I need the comma at the beginning of the GetObject parenthesis?

    Thx, Kathy

    Thx, Kathy

  98. Kathy Genakos

    still not working for me 8( I'm just going to have to instruct the users to be logged onto Outlook.

    I'm going to try to add code to prompt the File/Save As function.

  99. Kathy Genakos

    Hi, Diane:

    The GetObject/CreateObject code is not opening Outlook. My latest effort was to try and change the title in the MsgBox. I looked at an example on msdn.com but still can't reproduce. Ugh!

  100. Kathy Genakos

    Diane: I will try to find the MsgBox example from msdn. Thanks for offering to research further.

    However, I have a much more important issue that was just uncovered in unit testing:

    My colleague used the Excel doc with the VBA (that includes launching the custom email form) but her company default email form launched instead. This defeats the whole purpose of writing the VBA!

    Once I walked her through the steps of how to "open" the custom email form from Outlook's Organizational Forms Library, the Excel VBA auto-opened the custom email form and everything else worked as expected.

    Below is my existing code for launching the custom mail portion of the VBA:

    Set OutApp = CreateObject("Outlook.Application")
    Set Items = OutApp.ActiveExplorer.CurrentFolder.Items
    Set OutMail = Items.Add("ipm.note.TEST - US HRBP ONLY - HR Mass Change Request")

    Is there more VBA I need to enter to "initially" place the custom email form from the Organizational Forms Library to the users' filepath:

    C:\Users\\AppData\Local\Microsoft\FORMS\IPM.Note.

    Thanks!

    Kathy

  101. Jason Kelley

    Hi Diane,

    I created a custom meeting that has a "catering form". The purpose of it is to allow people to create a meeting request and then click the form to include catering for that meeting. The meetings can be in one of 13 exchange room mailbox calendars. I found out that Microsoft does not allow the "Auto approval" of forms that contain client-side vbscript. I have script in there to perform the printing and saving/copying functions. There is only one way (that I know of) around this. That is to have a macro (with the outlook rule) auto-approve the meetings. The only problem is that I need to keep Outlook open with the room mailbox as the primary account for it to work. And, I need to do this for 12 more rooms mailboxes ;-) So, I've been looking into using "ExtraOutlook.exe" to run multiple instances of Outlook with different profiles under the same windows login. Is there any way you know of around this, maybe a hack or some hotfix? I saw that IBM has a hotfix for this same problem available but it is for one of their products.

  102. Kathy Genakos

    I tried replacing my Set Items with
    Set items = Session.GetDefaultFolder(olFolderInbox).items

    I got a "424" Object required err msg.

    I tried Dim Session As Object

    Then I got a "91" error msg Object variable not set

    Sorry to be such a bother....we're sooooo close....

    Kathy

  103. Kathy Genakos

    Hi, Diane: Not sure if you rec'd my post from yesterday. I changed the Set items statement with

    Set items = Session.GetDefaultFolder(olFolderInbox).items

    I rec'd an error msg that seemed to want

    Dim Session As Object

    ...but still isn't working.

    Can I use the path to the SYSTEM public folder for under the folder called EFORMS REGISTRY to the folder called ORGANIZATIONAL FORMS? If so, would you know what that VBA code would be in Excel?

    Thx, Kathy

  104. Kathy Genakos

    Hi, Diane: I was surfing the Web to see if I could find out anything more re: Outlook IPM.Notes

    Would the below URL have helpful info for trying to create VBA code that would initially launch my custom Outlook 20120 email (IPM.Note) form in Excel? If not, I'll have to instruct the users to access this custom email form manually (one time only).

    http://msdn.microsoft.com/en-us/library/cc815825(v=office.14).aspx

    Thx, Kathy

  105. Kathy Genakos

    Hi, Diane: I'm still stuck on how to code VBA in Excel 2010 when the user has never accessed my custom email form in Outlook 2010. My custom email form is named: ipm.note.TEST - US HRBP ONLY - HR Mass Change Request

    Apparently it is stored in a SYSTEM public folder under the folder called EFORMS REGISTRY. Then I believe there's another folder called ORGANIZATIONAL FORMS.

    I'm hoping you might be able to help me find this filepath (maybe it's hidden??) and/or help me with the VBA to launch the custom email form "if" it has never been used before. (This should only need to be done once for a user)

    Some good news though...after much searching and a bit of modifying I now have VBA code in Excel 2010 that looks to see if the user has Outlook 2010 open (displaying a msgbox in Excel either way). If Outlook is not open, when the user clicks the OK button in msgbox, Outlook automatically launches! Thought I'd share this code with you even though you probably already have it:

    Sub check_is_running()

    Dim ret As Long
    Dim Process As Object
    Dim proc_name As String
    Dim bl As Boolean
    proc_name = "Outlook.exe" '\change process name here
    bl = False
    For Each Process In GetObject("winmgmts:").ExecQuery("Select Name from Win32_Process Where Name = '" & proc_name & "'")
    If UCase(Process.Name) = UCase(proc_name) Then
    bl = True
    Exit For
    End If
    Next Process

    If bl = False Then
    MsgBox "Outlook is not open"
    Else
    MsgBox "Outlook is open"
    End If

    On Error Resume Next
    Set ObjOutlookApp = GetObject(, "Outlook.Application")
    If Err.Number 0 Then
    Set ObjOutlookApp = CreateObject("Outlook.Application")
    Shell ObjOutlookApp.Application, vbMaximizedFocus
    End If
    On Error GoTo 0

    End Sub

  106. jmkelley2

    That would be awesome if I was able to answer all 13 room mailboxes with one instance of outlook. I am very new to macro programming, so how would one use the itemadd macro to perform this function? I am what you call a gogrammer , one that searches for prexisting code with google and reverse-engineers it ;-)

  107. Kathy Genakos

    After executing this Excel 2010 VBA for Outlook 2010 custom email (IPM.Note.x) would you know the code to then make the custom email's Subject line read-only?

    .Subject = Worksheets("Subject").Range("A1").Value

  108. Kathy Genakos

    You can disregard my previous comment. Setting the subject line to read (or locked) whatever that property says, allows my code to auto-pop the value from Excel into the subject line while retaining the read-only feature so the user can't tamper with it! (Not sure exactly how this is possible...but it does work) THANKS for ALL of your help throughout my learning process. I've learned so much about VBA and custom Outlook emails from the past 0 to 30 days, thanks in large part to your willingness to share your expertise! Kathy

  109. jmkelley2

    Hi Diane,

    Thanks for the information! I have a couple of questions/issues concerning the implementation of the macro. I tried using the code below to listen for two mailboxes but I am getting an error message when Outlook opens. It throws a "Compile error: Sub or Function not defined" error, and the "GetFolderPath" in the code below is highlighted blue. Also, your original "autoaccept" macro (same code is used below) is fired by an Outlook rule. I have an invisible textbox on my custom form that has "sometext" in it. The rule looks for that textbox on the custom form and the value of the text. That is how is can tell the difference between the custom catering form and regular meeting requests. How does this work with the item_add macro? How do I get the macro to fire for each individual mailbox? Here is the code I have so far:

    Private Sub Application_Startup()
    Dim Ns As Outlook.NameSpace
    Set Ns = Application.GetNamespace("MAPI")
    Set Items1 = GetFolderPath("CNF-***1\Inbox").Items
    Set Items2 = GetFolderPath("CNF-***2\Inbox").Items
    End Sub

    Private Sub Items1_ItemAdd(ByVal Item As Object)
    If oRequest.MessageClass "IPM.Schedule.Meeting.Request" Then
    Exit Sub
    End If

    Dim oAppt As AppointmentItem
    Set oAppt = oRequest.GetAssociatedAppointment(True)

    Dim myAcct As Outlook.Recipient
    Dim myFB As String

    Set myAcct = Session.CreateRecipient("cnf-***1@mydomain.org")

    myFB = myAcct.FreeBusy(oAppt.Start, 5, False)

    Dim oResponse
    Dim i As Long
    Dim test As String

    i = (TimeValue(oAppt.Start) * 120)
    test = Mid(myFB, i - 2, (oAppt.Duration / 5) + 2)

    If InStr(1, test, "1") Then
    Set oResponse = oAppt.Respond(olMeetingDeclined, True)
    oResponse.Send

    Else
    Set oResponse = oAppt.Respond(olMeetingAccepted, True)
    oResponse.Send
    End If
    End Sub

    Private Sub Items2_ItemAdd(ByVal Item As Object)
    If oRequest.MessageClass "IPM.Schedule.Meeting.Request" Then
    Exit Sub
    End If

    Dim oAppt As AppointmentItem
    Set oAppt = oRequest.GetAssociatedAppointment(True)

    Dim myAcct As Outlook.Recipient
    Dim myFB As String

    Set myAcct = Session.CreateRecipient("cnf-***2@mydomain.org")

    myFB = myAcct.FreeBusy(oAppt.Start, 5, False)

    Dim oResponse
    Dim i As Long
    Dim test As String

    i = (TimeValue(oAppt.Start) * 120)
    test = Mid(myFB, i - 2, (oAppt.Duration / 5) + 2)

    If InStr(1, test, "1") Then
    Set oResponse = oAppt.Respond(olMeetingDeclined, True)
    oResponse.Send

    Else
    Set oResponse = oAppt.Respond(olMeetingAccepted, True)
    oResponse.Send
    End If
    End Sub

    Thanks in advance for your help!

  110. Andrew

    Hi Dianne,

    I created an Outlook Form and It has a number of text fields that the end user needs to complete. I am testing this on my profile before distributing but when I receive the email the contents of the text fields are blank. I have copied the compose page into the read page so the data is the same and I think the fields should be bound. I have also checked and tested with "Send form definition with item" is enabled and again with this option disabled.
    Any ideas what could I have done wrong or not setup correctly?

  111. Cathy Desjarlais

    Hi Diane,
    I am hoping you can help. I am in Outlook trying to create a custom form. I found one in the Organization Library that had the same type of fields I wanted to use so I took that one and I have edited it to have different field names, ect. It looks great! When I run the form, it still looks great. I fill in some of the fields and send it to myself to test it and when I get the email, all the fields are diverted back to the original names (with my info in the fields that I entered). Can you tell me how I can make it show my info with the new fields that i have created? This is so frustrating :( Thanks, Cathy

  112. jmkelley2

    Hi DIane,

    I posted a response to your answer about a week and a half ago. I was not sure if it went through successfully or not. I am having trouble with the "GetFolderPath()" line, an error pops up that says "Compile error: Sub or Function not defined" and this is highlighted in blue. I tried. I have the following line: GetFolderPath("CNF-Classroom\inbox").Items . The "CNF-Classroom" is the name of the mailbox. Any ideas? I tried putting the code in a "Class Module" and also just a "Module" to no avail.

    Thanks!

  113. Sares

    Hi Diane, i follwoed your instructions as above and managed to build a custom form sucessfully. However, im required to post the values from the custom form & custom fields that i have created to my Sharepoint list. Currently i am only able to post the values which are on the main fields of the task list shown in outlook. The values from my custom form and custom fields dont seem to get updated in the list at sharepoint. Do you know why or any tips on getting it posted successfully? Im using 2007 version of both outlook and sharepoint. Thanks!

  114. sares

    HiDiane, do you know how to get values from my custom fields and custom forms posted to sharepoint list? Currently it is in-sync but only fields from the main form will get posted in the sharepoint list.

  115. sares

    Hi Diane, Thanks so much for your reply. From yourn experience is it possible to insert codes inorder to make this work?

  116. jmkelley2

    Thanks! that is a great idea, but I am having a problem using it. When a regular meeting request is sent to the conference room, it throws an error because the "oRequest.UserProperties(APPROVEME)" custom field does not exist on it. Is there a way I can exclude the regular meetings by making an "If exist" loop (if one exists) or by some other way?

  117. Christopher Klabunde

    Hi Diane,,
    I am currently designing a custom form. I want the users to be able to add attachments to the form. I figured that I need to add the message field to my form. However, I don't want the message content to be displayed (already tried Visible = False) - > I only need the attachment option /possibilty. Is there any workaround for this ?

  118. Janna

    Hi Diane,
    Thank you for this wonderful resource you have built for us. I need some help with a form in Outlook 2007. I made a form message, simple with some "labels" and text boxes to fill in. I made the subject line, the email "to" and "cc" (they will always be the same). I ran it and also published it. And, I saved it as an OFT in my private library. When I open the OFT from my library and fill in the text fields, then send, I get an error message: Operation Failed. The message won't send. I have looked all over the web for an answer, to no avail. Do you have any ideas?

    Thank you,
    Janna

  119. Godha

    Hi Diane,

    I just learnt how disable reply all or forward and published a form in Outlook 2010, but what i am flummoxed about is that the recipient can change the email setting by redesigning the form back to reply all or forward working backwards in the same process.
    Please tell me is there a way to disable that?

    any early reply on this would be greatly appreciated.

  120. Christian

    Hello Diane,

    Hoping maybe you could help solve this mystery.

    I created a form.
    Under ThisOutlookSession I have: Public Sub LOCOwnership(itm As Outlook.MailItem)
    Within that sub I have a frm.show vbModal
    The form contains a combo box, and two buttons, OK and Cancel.

    Now for the mystery...

    When Outlook opens for the first time upon powering up the computer,
    I go to Rules...
    Manage Rules and Alerts...
    select Run Rules Now...
    I select the rule that will execute the macro LOCOwnership.

    Ok... so the form displays! Great!
    The combo box is populated, the OK and Cancel buttons work.
    I can select "Run Now" repeatedly and the form works.
    I can close the Run Rules Now widow, select "Run Rules Now" again and run the rule and the form works.

    NOW... if I close the Run Rules Now window... then close the Rules and Alerts window...
    Then try going back... and open the rules window and run now again... the form does not work. Meaning the combo box is not populated, the OK and Cancel buttons don't work when you click on them... This indicates the UserFrom_Initialize did not fire off.

    So once I run this rule I can never run it again until I restart Outlook!

    Do you have any idea what is happening to the form when I close the Rules and Alerts window that would cause the initialization of the form to not work?

  121. Christian

    I have seen a setting that locks down email to only the recipient and they in turn cannot save, reply all, or forward the email. (like a for your eyes only) At this time though I am unable to relocate that ability.

  122. Haim Moshe

    Hi Diane

    Your information is worth GOLD

    I have reviewed most of the material on the outlook forms
    i have created a Task Assignment form customized to my needs without VBA and did the following:

    1. Marked the "send form properties"
    2. same read and write page
    3. published the form
    4. Sent the fdm file to a different user
    5. He then installed it in his private forms library
    6. I then sent him a task assignment using the same form

    Results:

    1. He received the task in the inbox
    2. Cannot open it
    3. Cannot delete it and cannot even move it to the delete folder ("One or more parameters are not valid")
    4. He can send me a task using the form but when i get it i also cannot open it and cannot delete it

    I will more then appreciate your help through this

    Haim

  123. Kim

    I created a custom task form that has page 2 but for some reason when the task is assigned to someone they cannot see page 2. I can open the task and see page 2 just fine. What do I need to do to make sure page 2 is visible for everyone?

  124. Kim

    Thank you soooo much! All I did was check the send forms definition box and it works perfect.

  125. Kim

    I have come across another issue I can't seem to figure out. I have several check boxes on page 2. When I fill out the form and check several of the check boxes and then assign the task the person the task was assigned to cannot view the check marks in the boxes. Any suggestions on this issue?

  126. Raj

    How can I retain embedded object with voting button reply?

    I have created an OFT template(Entry Form) with voting buttons . Whenever the user fills the entry form and sends it across to the Admin and the Admin approves/rejects the form and CC the response to his/her higher authorities at the same time . My question here is how to send the filled entry form along with response (as the admin approves/reject the form) or in other words How can I retain embedded object with voting button reply

    Thanks in Advance

  127. Jeff C

    I need to create a new e-mail message and format it (populate the "to" field, subject and body). Templates won't work because the data varies from week to week, and I'd prefer not having to overlay/update the template data. Is a custom form what I need? If so then can you direct me to tutorial that explains the basics (setting up the form controls, populating the message fields, invoking and submitting the form)?

    Thanks.

  128. Distressed Admin Asst

    I am trying to edit a "Meeting Request" form. I want to copy some of the pre-existing fields (Start time, End time, All day event) and put them into a custom form I am designing. The fields have options I can not find anywhere else (drop down menus to select a date off a calendar, etc.). Also, the "All day event" check-box voids out the time fields if checked.
    How can I copy or recreate this? How do I edit an existing form- not just add to it, but delete and rearrange things?
    My "Tools" group in the Developer ribbon is grayed out-I can't select "Field Chooser". If I move to an empty page I can edit, but not on the "Appointment" page (where the things I want to edit are!)
    Please help!

  129. Max

    I have designed a custom form (Outlook 2013) for my organization. I have sent it as a test and it appears for the recipient. So far so good. However I have 2 issues / questions:

    1. Is there any way for the recipient to see the form in the actual message as opposed to having to click the form name by the folder icon in the top ribbon? i.e. Can I embed the form in the actual initial displayed message (I have ensured the Separate read pages are not checked)?

    2. Basically the final outcome we are looking for is that the recipient of the form needs to reply back to the original sender approving the details of the form. The sender would then need to save the approval reply and attach it to their expense claim (as .PDF or .TXT where PDF not possible). The issue is that when the recipient of the form replies back to the sender the form disappears. Is there anyway of making it visible?

    I hope this makes sense and that you can help!

  130. NC

    Hi Diane,

    Thank you so much for this resource. I have created a custom appointment form and written VBA code to export the new fields to excel. It all works as it should on my calendar. I received permission to publish the form in the Organizational Forms Library and I can get the custom form to display on the shared calendar from another user's pc. However, the VBA code does not carry through. Is this a permissions thing? Or did I set something up incorrectly? Thank you!

  131. Ann Pollin

    Hi Diane - I tried to customize the contact form in Outlook 2007 and the customization went okay, but then I realized that the custom design form itself was nothing like the actual (real) contact form that shows up in Outlook. Thinking that the problem was because I was using Outlook 2007, I upgraded to 2010, only to find the same problem. The design form that is "customizable" is an ancient minimal version of the real/current contact form that actually appears in Outlook. There is no point in customizing it, because I would lose all of the other features found in the real/current contact form. Looking online, it appears that this is a known flaw in all of the Outlook versions? The contact forms are "customizable" but only if you are willing to use an ancient minimalist version of the contact form? I am not a developer, and I can't code or work with the region workarounds. Can't Microsoft provide the actual/real forms for customization? What gives?

  132. zimaraJessica

    Hello,

    Thanks for this helpful tutorial. I've read through all of the comments, and I too am having trouble with making the form visible when sent as an email. Working with Outlook 2010, & I don't know if it's a Microsoft Exchange Server I am working with, but I believe so--when you set up your mailbox, that's the option you select to create your Outlook profile. Here is what I have tried from your replies to others above--maybe I am missing something?

    1. I started by creating a new email, then saved it as a template.
    2. I selected Design a Form from the Developer tab and selected my template from the User Templates in File System.
    3. Designed my form. I didn't add any code to it; just a few check boxes from the Field Chooser.
    4. I saved the template again (.oft) in the User Templates in File System. The form did not display when sent to others.
    5. I reopened the template, and the form is still there. I verified that Separate Read Layout is not selected. I went to the properties tab and enabled sending the form definition. Still no form displayed.
    6. Next I published the form to Personal Forms Library. No go.
    7. I tried to publish the form to the Organizational Forms Library, that wanted me to disable sending the form definitions. I tried to publish both with and without sending the definitions; both times I get this error: "The form cannot be installed because you do not have owner permissions." I wasn't sure if this was owner permissions for the form or the library. So I went into the File tab of the form and clicked on Set Permissions. It is set to "no restrictions," and if I click on Manage Credentials, it wants me to sign up for the Information Rights Management Service.

    Based on your responses to others, I'm guessing that my problem is not having the form published to the Organizational Forms Library (even though I can't see the form even when I send it to myself), but I'm not sure. So my questions would be:

    1. If the issue is the Organizational library, do I need to have our IT department publish the form there? Because I'm thinking I don't have permissions just in the same way I don't have permission to download and install software, for example.

    2. If I were able to get the form published to the Organizational library, & that doesn't work, could there be anything else causing this problem based on what I've described above? I've created a macro to open the template which creates the form, and added that action to the ribbon so I have one-click access to open the email. The form displays, works correctly--just disappears when I hit send. Am I misunderstanding something about using forms and templates together, and the difference between using a template versus a form, or saving versus publishing?

    Sorry this is so long, I've just run out of options on things to try on my own, so wanted to give you as much info as possible. If you would be willing to take a stab at my questions that would be amazing. Thanks so much, I appreciate your time & help.

Leave a Reply

If the Post Coment button disappears, press your Tab key.