+ Reply to Thread
Results 1 to 8 of 8

Using .attachments.add to attach an excel file to an outlook email

  1. #1
    Registered User
    Join Date
    11-06-2014
    Location
    Green Bay
    MS-Off Ver
    2010
    Posts
    5

    Using .attachments.add to attach an excel file to an outlook email

    We have a file that creates a new outlook email to send to a specific email address and attach an excel file to the email - This was working a few months ago with no issues our code is using basic .attachments.add line to do this. When we get our outlook message with the attachment to pop up the To;CC; Subject lines go funky and you are not able to press the Send button. You are able to use the Alt+s short key to send the email but not able to edit the to cc subject lines within the email itself. Any idea what could fix this?

  2. #2
    Registered User
    Join Date
    11-06-2014
    Location
    Green Bay
    MS-Off Ver
    2010
    Posts
    5

    Re: Using .attachments.add to attach an excel file to an outlook email

    I have attached a Print screen
    Attached Images Attached Images

  3. #3
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Using .attachments.add to attach an excel file to an outlook email

    Please attach a sample file so that we could assist in your request. Thanks

  4. #4
    Registered User
    Join Date
    11-06-2014
    Location
    Green Bay
    MS-Off Ver
    2010
    Posts
    5

    Re: Using .attachments.add to attach an excel file to an outlook email

    My file is complicated so I created a file with the same concept of the code and it does cause the same issue as my other file. The code was taken off a website for a fast test.
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Using .attachments.add to attach an excel file to an outlook email

    I tried your file on three different machines, and I was unable to duplicate the error you posted (hence the code worked perfectly.)
    Did you try is on another machine?

  6. #6
    Registered User
    Join Date
    11-06-2014
    Location
    Green Bay
    MS-Off Ver
    2010
    Posts
    5

    Re: Using .attachments.add to attach an excel file to an outlook email

    We have had users that do not have the issue and we have users that do. It will work one moment then the next it is not working again. I just started having the issue today and trying to see if there was any updates that are corresponding but nothing is coming up as the same issue but I have seen some of the updates working with attachments so I am leaning toward an update but was hoping someone knew another way to code this to around the Microsoft update that maybe broke this line of code? I have seen alot of the attachment "fixes" with the KB3191938 update https://support.microsoft.com/en-us/...013june13,2017

  7. #7
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Using .attachments.add to attach an excel file to an outlook email

    I have been working in IT for many years (too long); and I had my moments addressing MS updates bugs where some systems stopped performing a regular task, while others experience no issues. My recommendation would be to address this issue with your IT personnel to see if there were any recent updates, then work your way backwards from there.

  8. #8
    Registered User
    Join Date
    11-06-2014
    Location
    Green Bay
    MS-Off Ver
    2010
    Posts
    5

    Re: Using .attachments.add to attach an excel file to an outlook email

    They are part of the reason I posted the question - they are not helping they blame the code which doesnt make sense if it works here and there and has worked for over 10ish years then one day all of a sudden the code is broke? Besides the fact that we are using VBA for a document that has no business on being in excel we just have to peice to gether fixes as they come up and everytime this comes up I have to figure it out to tell our IT department how to fix.

+ 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] Problem with VBA code to attach file to email using a pre saved Outlook template
    By Wooltrain in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-12-2017, 08:28 PM
  2. attach file in an outlook email from specific folder
    By 9599lorenzo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2017, 07:07 AM
  3. Using VBA to attach temp Excel sheet and email with Outlook
    By TBrophy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2015, 04:50 PM
  4. [SOLVED] Macro to attach an additional file to and outlook email
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-18-2014, 01:27 PM
  5. copy data from outlook email attachments to a local file
    By s_samira_21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2014, 10:24 AM
  6. Excel Macro to download email attachments from MS Outlook.
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-06-2010, 02:10 PM
  7. adding multiple attachments to a macro in excel for a email using outlook
    By ccbltdneedhelp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2009, 11:03 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