Compile error..

Status
Not open for further replies.
P

Peter

Hi all,

i use this code in the "on click" event of a command button in a Access

form...

Dim objOutlook As Outlook.Application

Dim objEmail As Outlook.MailItem

Set objOutlook = CreateObject

Set objEmail = objOutlook.CreateItem(olMailItem)

However..i receive:

Compile error:

User-defined type not defined

Does this imply that I need to add a module:?

Thanks!
 
Which line produces that error?

Did you add Outlook to your project references?

Alse, the line

Set objOutlook = CreateObject

must be changed to

Set objOutlook = CreateObject("Outlook.Application")

Dmitry Streblechenko (MVP)

-

"Peter" <Peter> wrote in message

news:F996BC47-8A5C-4A8C-898D-765F5BD18852@microsoft.com...
> Hi all,

> i use this code in the "on click" event of a command button in a Access
> form...

> Dim objOutlook As Outlook.Application
> Dim objEmail As Outlook.MailItem

> Set objOutlook = CreateObject
> Set objEmail = objOutlook.CreateItem(olMailItem)

> However..i receive:

> Compile error:

> User-defined type not defined

> Does this imply that I need to add a module:?

> Thanks!
>
 
Thanks for your reply Dimitry...

well..i see now that the error is what you mentioned..

How do i set Outlook to my project reference?

Thanks!

"Dmitry Streblechenko" wrote:


> Which line produces that error?
> Did you add Outlook to your project references?
> Alse, the line
> Set objOutlook = CreateObject
> must be changed to
> Set objOutlook = CreateObject("Outlook.Application")

> > Dmitry Streblechenko (MVP)
>

>

>

> -
> "Peter" <Peter> wrote in message
> news:F996BC47-8A5C-4A8C-898D-765F5BD18852@microsoft.com...
> > Hi all,
> > i use this code in the "on click" event of a command button in a Access
> > form...
> > Dim objOutlook As Outlook.Application
> > Dim objEmail As Outlook.MailItem
> > Set objOutlook = CreateObject
> > Set objEmail = objOutlook.CreateItem(olMailItem)
> > However..i receive:
> > Compile error:
> > User-defined type not defined
> > Does this imply that I need to add a module:?
> > Thanks!
> >


> .
>
 
Click Tools | References in the VBA editor.

Dmitry Streblechenko (MVP)

-

"Peter" <Peter> wrote in message

news:26A20B73-8A16-495D-B3E4-4FACFBD83F15@microsoft.com...
> Thanks for your reply Dimitry...

> well..i see now that the error is what you mentioned..

> How do i set Outlook to my project reference?

> Thanks!

> "Dmitry Streblechenko" wrote:
>
> > Which line produces that error?
> > Did you add Outlook to your project references?
> > Alse, the line
> > Set objOutlook = CreateObject
> > must be changed to
> > Set objOutlook = CreateObject("Outlook.Application")
>

>> > > Dmitry Streblechenko (MVP)
> >

> >

> >

> > -
> > "Peter" <Peter> wrote in message
> > news:F996BC47-8A5C-4A8C-898D-765F5BD18852@microsoft.com...
> > > Hi all,
> >> > i use this code in the "on click" event of a command button in a Access
> > > form...
> >> > Dim objOutlook As Outlook.Application
> > > Dim objEmail As Outlook.MailItem
> >> > Set objOutlook = CreateObject
> > > Set objEmail = objOutlook.CreateItem(olMailItem)
> >> > However..i receive:
> >> > Compile error:
> >> > User-defined type not defined
> >> > Does this imply that I need to add a module:?
> >> > Thanks!
> > >

>

>
>> .
> >
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
M Compile error: User-defined type not defined Outlook VBA and Custom Forms 0
C compile error on previously functioning code outlook 2003 windows Outlook VBA and Custom Forms 1
B Compile error: Object required Outlook VBA and Custom Forms 2
L Error when exporting Sent Mail to Excel Outlook VBA and Custom Forms 6
G Outlook 365 My iCloud Outlook doesn’t work after reinstalling Microsoft365 on Windows 10 PC – now I get error message on contacts and calendar Using Outlook 1
V Outlook Error The Attempted operation Failed. An Object Could Not be found Outlook VBA and Custom Forms 0
S macro error 4605 Outlook VBA and Custom Forms 0
humility36 Cannot move emails to archive - 440 error Outlook VBA and Custom Forms 1
D.Moore Strange VBA error Outlook VBA and Custom Forms 4
T Event Error on non existent Event. Using Outlook 2
P now on office 365 but getting error messages about missing Outlook 2013 cache folders Using Outlook 2
W Outlook 365 I am getting the "Either there is no default mail client" error when I try to send an email on excel Office 365 Using Outlook 1
A Links in email getting error message about group policy Using Outlook 4
Aussie Outlook 365 Rule runs manually but returns the error code "an unexpected error has occurred" when incoming mail arrives Using Outlook 1
Cathy Rhone Mail merge error message Using Outlook 1
U Outlook 2019 VBA run-time error 424 Outlook VBA and Custom Forms 2
V Outlook error 500 Using Outlook 2
O Comma Separated Values.ADR and A file error has occurred in the translator Using Outlook 6
D We're sorry but outlook has run into an error Using Outlook 6
D Outlook 2016 Outlook Error Msg "The operation cannot be performed ..." How to Stop it Using Outlook 4
P Outlook 2013 All imported Mail Rules in error when imported into new profile Using Outlook 5
H Outlook 2019 Certificate error Using Outlook 2
V Date and/or time error in Outlook Form Outlook VBA and Custom Forms 0
A Run-time error '430' on certain emails when trying to set "Outlook.mailitem" as "ActiveExplorer.Selection.Item" Outlook VBA and Custom Forms 2
E Complite error on SaveAsFile method Outlook VBA and Custom Forms 2
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
D Outlook VBA error extracting property data from GetRules collection Outlook VBA and Custom Forms 10
A Unable to save recurring Meeting to Documents folder due to error Using Outlook 2
R Error when trying to forward current email item Outlook VBA and Custom Forms 7
M ERROR: None of your email accounts could send to this recipient Using Outlook 2
J OLADD.FAE Error When Exporting Contacts Using Outlook 6
C Send/receive error 80040119 Using Outlook 2
W error with the permission for the file Outlook VBA and Custom Forms 0
L Outlook 2019 MAC sync error after working for 4 hours Using Outlook 1
A Run time error 424. object required in outlook 2013 Outlook VBA and Custom Forms 10
M error code 0x8DE00006 Using Outlook 1
M Desktop Version Of Outlook Generating Error Using Outlook 4
M Send/Receive error 0x800CCC0F Using Outlook 0
T Outlook 2016 CSV Translator Import Error Using Outlook 6
ManaarZakaria I'm afraid of this issue, cause of strange error Exchange Server Administration 2
P Suppress dialog box on email check error? Using Outlook 5
vodkasoda Object could not be found Error in Outlook 2007 Outlook VBA and Custom Forms 5
S VBA Macro - Run-time error '424': object required - Help Please Outlook VBA and Custom Forms 3
avant-guvnor Outlook.Application now produces error Outlook VBA and Custom Forms 5
P Run Time Error 91 when linking contact to task in VBA Outlook VBA and Custom Forms 1
N Error 0x80090326 when trying to setup IMAP account on Outlook.com Using Outlook.com accounts in Outlook 1
N Saving And Deleting Outlook Attachments with Unknown Error Message Outlook VBA and Custom Forms 1
Dennis Gaudenzi Your setup couldn't be started because of an unexpected error (mapi 0x80040604) Using Outlook 14
M Outlook 2013 fails to start -- missing WindowsCodecs.dll error Using Outlook 3
Steshelter ICloud Unexpected Error Using Outlook 5

Similar threads

Back
Top