Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: User-defined type not defined

  1. #1
    Join Date
    5th July 2005
    Posts
    325

    User-defined type not defined

    I have some code:
    When I run it I get error "User-defined type not defined excel vba Outlook.Application".
    VB:
    Sub SendEmails() 
         
        Dim olApp As Outlook.Application 
        Dim olMail As MailItem 
         
        Set olApp = New Outlook.Application 
    
    
    May you helpme to find the problem.

    Thanks in advance.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Posts
    10,539

    Re: User-defined type not defined

    You need to set a reference to the Microsoft Outlook Object Library in Tools>References...

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    5th July 2005
    Posts
    325

    Re: User-defined type not defined

    Prompt & simple..
    Norie, thank you.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    10th March 2005
    Location
    Colorado
    Posts
    2

    Re: User-defined type not defined

    What if Reference to the Microsoft Outlook Object Library in Tools>References is set and still get error. Error also reads "Outlook is not available"

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,429

    Re: User-defined type not defined

    Quote Originally Posted by Dw6853
    What if Reference to the Microsoft Outlook Object Library in Tools>References is set and still get error. Error also reads "Outlook is not available"
    suggest that you actually read the Forum Rules that you agreed to.

    You should not hijack threads, but start your own with a reference to the other one if you think it will help
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  6. #6
    Join Date
    10th March 2005
    Location
    Colorado
    Posts
    2

    Re: User-defined type not defined

    my apologies; will do

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. User-defined Type Not Defined Error
    By touficdb in forum EXCEL HELP
    Replies: 11
    Last Post: June 28th, 2008, 14:31
  2. FileSystemObject: User-Defined Type Not Defined
    By bigblu89 in forum EXCEL HELP
    Replies: 12
    Last Post: November 29th, 2006, 10:12
  3. "Compile error: user-defined type not defined" in Excel VB6 Macro
    By desiboy in forum Excel and/or Access Help
    Replies: 3
    Last Post: December 28th, 2005, 01:15
  4. user defined type not defined
    By Blur in forum EXCEL HELP
    Replies: 3
    Last Post: October 14th, 2005, 17:47
  5. Replies: 3
    Last Post: September 27th, 2003, 02:35

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno