+ Reply to Thread
Results 1 to 4 of 4

Excel Error when trying to add attachment to email

  1. #1
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    Excel Error when trying to add attachment to email

    Hey guys amd gals, I am getting an error when trying to send an automated email with an attachement. Without the attachment it works just fine. I've done this before, with only minor changes to the code and it worked just fine, so I am at a loss now.

    Please Login or Register  to view this content.
    Here is my error:
    error.png

    When I debug, it highlights the first .Attachements.add

    However, if I comment out the first two attachments, and only try the third, it changes the error code to a 438.

    TIA for the help!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,934

    Re: Excel Error when trying to add attachment to email

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    Re: Excel Error when trying to add attachment to email

    Wow...

    I know better. Thank you, TMS.

    Can I use the "I am on pain killers and having surgery tomorrow" excuse?

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,934

    Re: Excel Error when trying to add attachment to email

    You're welcome. Thanks for the rep.

    Can I use the "I am on pain killers and having surgery tomorrow" excuse?
    Absolutely. Hairless and in need of surgery ... Good luck. Hope it's nothing serious. Get well soon Yes, I know, joke (I hope).




    Links directly to personal commercial services on your own blogs or code sites is prohibited.
    • Links in posts must be to relevant free solutions on your site.
    • Links in signatures must be to landing site of your blog that clearly promotes the free material above the commercial offerings.
    • Cross-promotion of, or links to, forums competitive to this forum in signatures or posts is prohibited.

+ 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. Sometimes getting run time error 91 when running macro to email attachment
    By armlegx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2017, 06:37 PM
  2. excel attachment to email
    By santbiju1 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 08-31-2015, 09:02 AM
  3. olMail - Email Attachment Variable. Sending Email through Excel
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2014, 07:55 AM
  4. olMail - Email Attachment Variable. Sending Email through Excel
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2014, 07:41 AM
  5. email excel file or worksheet as an attachment to multiple email addresses
    By jgeagle5 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-16-2009, 03:40 PM
  6. Error Trying to email attachment
    By hriggs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2008, 04:26 AM
  7. attachment - then email from excel!
    By dj_siek in forum Excel General
    Replies: 0
    Last Post: 02-14-2006, 10: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