Solved

Create Macro enabled *.oft file

Posted on 2009-04-02
9
1,391 Views
Last Modified: 2012-05-06
I want to use outlook VBA. I have a feed back form with activex controls (combo box, text box, option button etc,.) After I fininshed my designing I set my outlook security zone at internet zone. Now I can view what I designed. But I fail to understand what else needs to be done so that my recipients can get the macro enable *.oft file. And they also can see the automation like clicking on dropdown added names will populate. By clicking on a option button they can choose a particular option etc. Can you share with me a Macro enabled *.oft file? ANd how do I that? Thank you.
0
Comment
Question by:suvmitra
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 76

Expert Comment

by:David Lee
ID: 24053660
Hi, suvmitra.

So you've created a custom Outlook form usign additional controls.  When you send the form to others they aren't seeing the controls.  Is that right?  If it is, then are the recipients in your organization or outside of it?  What version of Outlook are you using?  What version are the recipients using?  Have you published the form?  Do the recipients have all the controls you used in the form installed on their computers?
0
 
LVL 9

Author Comment

by:suvmitra
ID: 24056997
Thanks for following up. I am using MS Office Outlook 2003. And my target recipients are also using the same. I need a sample of working macro / vba enabled *.oft / outlook message to see how this works after sending.
0
 
LVL 76

Expert Comment

by:David Lee
ID: 24060134
There is no such thing as a "macro / vba enabled *.oft / outlook message".  Custom Outlook forms can have VBScript behind them that's part of the message object itself.  Macros are written using VBA and exist outside of message objects.  They are blocks of code that are stored in the client.  They do not get sent with a message and they are in no way connected to a specific message or form.  

I'll be glad to help you figure this out, but I can only do that if you answer all the questions I posed.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Author Comment

by:suvmitra
ID: 24076856
I am attaching an excel file. I want to create the same into Outlook. And I want exactly same what has into the attached template. I want My recipients will be getting this activeX enabled outlook message they will fillup the form and send it across to me. Is that possible? I need experts help on this.
Request-Form.xls
0
 
LVL 9

Author Comment

by:suvmitra
ID: 24076871
Sorry the attached one was blank! Use this one.
Request.xls
0
 
LVL 76

Expert Comment

by:David Lee
ID: 24083406
Unless I'm missing something you don't need a macro or VBA to duplicate that form.  I don't see any code behind it giving it any intelligence.  It's just layout.  You can duplicate this in two ways.  Create a custom form and layout the fields using text boxes and radio buttons.  Create what amounts to a web form by laying this out using HTML.  Neither solution requires any scripting, code, VBA, etc.  The second approach is simpler to implement, especially if you're already comfortable with HTML.
0
 
LVL 9

Author Comment

by:suvmitra
ID: 24087941
I only need to draft the form as it is into the Excel file into Outlook. I want to use dropdpwn boxes, radio buttons...how do I design this? I need to send this form to my target recipients...I also want to make sure that they are getting exactly same..what I am drafting here.  Please help.
0
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 24089067
"... how do I design this?"
That's a little like asking "how do I design a car?"  The answer would take several pages of explanation.  I'm not going to reinvent the wheel when there are already several sources that walk through the process step by step.  Here's a link to the best resource I know of: http://www.outlookcode.com/article.aspx?ID=35  There are links on this page to every aspect of designing and building custom Outlook forms.
0
 
LVL 9

Author Comment

by:suvmitra
ID: 24090215
Sorry! Probably I was not clear enough. I sorted it out and my problem is resolved. I uploaded the output as test.jpg. Thank you for your help.
request.JPG
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question