Run time error 424. object required in outlook 2013

Status
Not open for further replies.
A

a1003520

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Hi
I was trying to build a custom based form in outlook 2013. I got the tutorial on News, Tips, and Advice for Technology Professionals - TechRepublic

I followed the step and was able to add a combobox to the form as well as a VB Script.

But each time i run the form the combobos did populate

And when I run it through the VBA script in outlook, it gave error message: Run-time error 424. Object required.

The VB code is

Sub Item_Open()
Set FormPage = Item.GetInspector.ModifiedFormPages("General")

Set Control = FormPage.Controls("cboDepartment")

Control.PossibleValues = "Administrative;Accounting;IT"


End Sub

Pls any suggestion to correct this message.

The 2nd problem....
I would like to populate the combobox through excel range/ cells. Could anyone suggested how I can run excel in outlook VBA while connecting the excel range to populate the combobox

Thanks
 
You need to edit the registry to allow script in custom forms.
See Custom Form Security Changes for more information.

The code likely errors in VB Editor because it cant find this object - Item.GetInspector.ModifiedFormPages("General")
 
THank Diane
I checked the link but I couldnt really understand what need to be done:

"You can use this sample registry file to add the Outlook 2013 32-bit/Windows 64-bit keys to the registry. Save it as a text file and add your form names to the TrustedFormScriptList key, then save as a reg file and double click to run. "

Below is the TrustedFormScriptList, but where do I save it to and how do i run it:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\15.0\Outlook\Forms\TrustedFormScriptList]
"IPM.Contact"=""
"IPM.Contact.script-test"=""

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\15.0\Outlook\Security]
"DisableCustomFormItemScript"=dword:00000000
 
paste this into notepad - if the published form is not called script-test, change the name to what you called it

Code: 
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\15.0\Outlook\Forms\TrustedFormScriptList]
"IPM.Contact"=""
"IPM.Contact.script-test"=""

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\15.0\Outlook\Security]
"DisableCustomFormItemScript"=dword:00000000
 
ok. Now Its getting clearer.
You mean I have to paste the code in notepad, then save it or import the text file to the registry editor?
 
You can either save it (the stuff in the code window) as a reg file (paste into notepad, save, change the extension to reg) so you can double click to run it. Or browse to that location in the registry editor (creating the keys as needed) and create the values.
 
Hi Diane
Thanks again. Yes I was able to import the file into the registry successfuly, so there are 3 available file to be run. Each time I try to run each, especially the last one which has the form name, the window ask for value... I left it blank and nothing happened. So what should I fill into the value

Aslo will i run all the three information. (1) Default (2) IPM.Contact (3) IPM.Contact.General

Find attach the screenshot

1539680115739.png
 
Hi Diane
Well I have decided to build the userform in outlook and just paste it to the outlook email body..
However, I want to PrintScreen the userform and paste in the outlook email body.
The code perfectly works fine when I built it in excel, but did work in outlook vba.
There is a problem with using the Application.Sendkeys in outlook

Can you offer any solution on how to use this command in outlook vba?

Here is my screenshot

1539768665431.png
 
Diane Poremsky said:
paste this into notepad - if the published form is not called script-test, change the name to what you called it

Code: 
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\15.0\Outlook\Forms\TrustedFormScriptList]
"IPM.Contact"=""
"IPM.Contact.script-test"=""

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\15.0\Outlook\Security]
"DisableCustomFormItemScript"=dword:00000000
Click to expand...

Hi Diane
Just wanna be sure if I did the correct thing.. As per your suggestion.
The name of the form is IPM.Contact.NewContactForm (NewContactForm)
So will I enter the information as

Code: 
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\15.0\Outlook\Forms\TrustedFormScriptList]
"IPM.Contact.NewContactFrom"=""
"IPM.Contact.NewContactForm"=""

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\15.0\Outlook\Security]
"DisableCustomFormItemScript"=dword:00000000
[/QUOTE]
 
Status
Not open for further replies.
< Possible to hide ribbon with custom appointment form? | Macro to set the category of Deleted Item? >
Similar threads
Thread starter Title Forum Replies Date
U Outlook 2019 VBA run-time error 424 Outlook VBA and Custom Forms 2
S VBA Macro - Run-time error '424': object required - Help Please Outlook VBA and Custom Forms 3
D We're sorry but outlook has run into an error Using Outlook 6
A Run-time error '430' on certain emails when trying to set "Outlook.mailitem" as "ActiveExplorer.Selection.Item" Outlook VBA and Custom Forms 2
P Run Time Error 91 when linking contact to task in VBA Outlook VBA and Custom Forms 1
Vijay Error in rule- Run a script Using Outlook 1
A vb6 run time error 5 when Outlook 2007 Explorer object displayed Outlook VBA and Custom Forms 1
J Outlook macro to run before email is being send Outlook VBA and Custom Forms 3
J Outlook, Word, Access crash unless run in Admin mode - time dependent it seems Using Outlook 10
X Run macro automatically when a mail appears in the sent folder Using Outlook 5
V Outlook macros no longer run until VB editor is opened Outlook VBA and Custom Forms 0
J Want to create a button on the nav bar (module add-in) to run code Outlook VBA and Custom Forms 2
J Outlook Rules VBA Run a Script - Multiple Rules Outlook VBA and Custom Forms 0
N Outlook 2021 'Run Script" Rules? Outlook VBA and Custom Forms 4
T Outlook 2010 Errore run-time -2147417851 (80010105) Metodo delete ContactItem non riuscito Outlook VBA and Custom Forms 0
K Run a script rule to auto 'send again' on undeliverable emails? Outlook VBA and Custom Forms 1
G Save attachment run a script rule Outlook VBA and Custom Forms 0
D Outlook 2013 Macros only run in VB editor, not in drop down or button Outlook VBA and Custom Forms 14
M White square in body of Outlook Messages (O2016 Version 2012 32bit Click To Run) Using Outlook 4
E Having some trouble with a run-a-script rule (moving mail based on file type) Outlook VBA and Custom Forms 5
C Auto Run VBA Code on new email Outlook VBA and Custom Forms 1
Aussie Rules Run a Script on an Incoming Email OK and then the Email reverts Outlook VBA and Custom Forms 0
A Apply Selected Emails to outlook rules and Run Rules Using Outlook 5
B VBScript doesn't run on Recipient Email Outlook VBA and Custom Forms 2
S Outlook Custom Form Scripting only working when clicking on "Run this form" Outlook VBA and Custom Forms 2
Y Outlook 2013 Run A Script Outlook VBA and Custom Forms 4
O Outlook 2016 This rule will only run when you check your email in Outlook.... Using Outlook 4
B run scripts Using Outlook 1
Dave A Run macro on existing appointment when it changes Outlook VBA and Custom Forms 1
O Run macro automatically at sending an email Using Outlook 11
P errors appear every time I run SCANPST Using Outlook 3
B Outlook rule run a Script doesn't work Outlook VBA and Custom Forms 1
B Wanting to run a script that will filter any body that has a russian link in it. Outlook VBA and Custom Forms 5
O Having rules run on old mails noved to inbox Outlook VBA and Custom Forms 8
Bri the Tech Guy Registry Tweak to make "Run a Script" Action Available Outlook VBA and Custom Forms 2
Bri the Tech Guy Run Script rule not running for newly arriving messages Outlook VBA and Custom Forms 25
J Custom form code doesn't run Outlook VBA and Custom Forms 2
J VBA Run When Reply Outlook VBA and Custom Forms 4
Vijay Run script doesn't work in outlook Using Outlook 1
O VBA to Run Font Change on Outlook Startup Outlook VBA and Custom Forms 4
D Creating an outlook session from Access vba but run silently. With A specific profile Outlook VBA and Custom Forms 1
Diane Poremsky Run a Script Rule: Send a New Message when a Message Arrives Using Outlook 2
Diane Poremsky Using Scanpst in Outlook Click to Run Using Outlook 0
oliv- How to Run a Script IN AN ADDIN with Outlook's Rules and Alerts Outlook VBA and Custom Forms 2
L Run a Script Rule doesn't work Using Outlook 5
B Can't run macro from QAT when emailing from Acrobat Outlook VBA and Custom Forms 0
J Outlook 2010 VBScript editor does not run code at all Outlook VBA and Custom Forms 0
X Outlook script to run excel data Outlook VBA and Custom Forms 1
D How to Run a Report Based on Age of Inbox Items Outlook VBA and Custom Forms 0
D RUN SCRIPT WHEN OUTLOOK IS CLOSE Outlook VBA and Custom Forms 1

Similar threads

Back
Top