+ Reply to Thread
Results 1 to 3 of 3

Run-time error "Method "Add" of object "Attachments" failed" - HELP

  1. #1
    Registered User
    Join Date
    09-20-2021
    Location
    Denmark
    MS-Off Ver
    Excel 2013/2016
    Posts
    8

    Run-time error "Method "Add" of object "Attachments" failed" - HELP

    Dear all,

    I am trying to run a macro that sends out emails, however when I try to run it I keep getting this error unfortunately:

    Run-time error "-2147..." Method "Add of object"Attchments"failed

    Can somebody please help me figure out why? I have tried setting source = ThisWorkbook.FullName (takes the current excel file I am typing in as an attachment) before and then typing EmailItem.Attachments.Add Source with no issues.

    For some reason this gives me an error now with the debug highlighting EmailItem.Attachments.Add Source

    Can somebody figure out why?

    Would be immensely greatful!

    Kind regards
    Jyggalag

    UNDECLARED croos post here: https://www.mrexcel.com/board/thread...ailed.1193353/
    Last edited by Glenn Kennedy; 01-20-2022 at 10:02 AM.

  2. #2
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2402-17328.20068
    Posts
    1,359

    Re: Run-time error "Method "Add" of object "Attachments" failed" - HELP

    You may need to paste your code.

    I would have one question at this stage: Is the workbook where the code resides saved somewhere?

    I ask because it will not let you attach the file otherwise.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Run-time error "Method "Add" of object "Attachments" failed" - HELP

    Welcome (back) to the forum.

    Thanks for your question. However, we have just found out that you have posted the same question elsewhere.... and haven't told us. Feel free to cross-post on other sites...

    But. Every forum has its rules. Please see Forum Rule #3 about cross-posting. So.

    Do not keep it a secret. We all are willing to give you our time, freely. However, some of us get very annoyed if we waste our time developing a solution for you, when you already have a nice solution elsewhere. All we ask is that you show us some respect and tell us:

    1) if you have cross-posted, and

    2) the URL of the cross posts.

    That way, those of us who don't want to waste their time can quickly check to see if you're already happy with another solution.

    (Note: since you are infrequent user of the site, on THIS occasion I have done it for you.)
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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. Run-time error -2147417848 (80010108) Method "Show" of object failed
    By brockbaker27 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-14-2021, 11:03 AM
  2. RUN-TIME ERROR Method "ExecWB" of object 'IWedBrowser 2' failed
    By dgarber in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2020, 12:15 PM
  3. Runt time error 1004 Method "Copy of object'_Worksheet failed"
    By mohansoft in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-20-2016, 03:15 AM
  4. Method "AddPicture" of object "InlineShapes" failed - but only one 1 computer
    By Alves76 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-20-2013, 10:49 AM
  5. Run time error 1004 method save as of object 1 "_workbook" failed.
    By json_79 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-09-2012, 02:41 AM
  6. "The "sheets" method from the "_Global" object have failed."
    By mankit87 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2011, 08:53 AM
  7. [SOLVED] What is Error "Method "Paste" of object "_Worksheet" failed?
    By vat in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-17-2006, 04:10 PM

Tags for this Thread

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