+ Reply to Thread
Results 1 to 5 of 5

getting compile error invalid or unqualified reference

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    getting compile error invalid or unqualified reference

    Hi friends,

    I want to send mails to all with attachment store in ‘OUTPUT’ folder. I’m getting compile error invalid or unqualified reference on the following line

    Please Login or Register  to view this content.
    Any help will be highly appreciated.

    Thanking you in anticipation.
    Attached Files Attached Files
    Sincerely,

    mso3

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,356

    Re: getting compile error invalid or unqualified reference

    Please Login or Register  to view this content.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: getting compile error invalid or unqualified reference

    Hi,

    You are missing

    Dim outmail As Object
    Set outmail = aOutlook.CreateItem(0)

    With outmail
    'wrapped around your If Len(Dir(strFileName)) > 0 Then.....Set aEmail = Nothing
    End With
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,356

    Re: getting compile error invalid or unqualified reference

    @ Richard

    It's there, but it is all over the place.

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: getting compile error invalid or unqualified reference

    Oof! What a silly mistake. Thank you for pointing out mistake. Now it’s working fine.

    Thank you and have a nice day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Getting error invalid or unqualified reference
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-20-2014, 08:15 PM
  2. [SOLVED] Getting error invalid or unqualified reference
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2014, 02:17 AM
  3. [SOLVED] Getting error invalid or unqualified reference
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2014, 11:31 PM
  4. [SOLVED] Invalid or Unqualified Reference Error
    By Trevasaurus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2013, 11:44 AM
  5. [SOLVED] VBA Debug (compile error invalid or unqualified reference)
    By Kezwick in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2012, 04:38 AM
  6. Invalid or unqualified reference error using the .Find in vba
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-08-2011, 07:10 PM
  7. Invalid or unqualified reference error when inserting a formula into a cell via VBA
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-11-2010, 10:06 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1