+ Reply to Thread
Results 1 to 3 of 3

Download Attachment and Rename With Subject Line v2

  1. #1
    Registered User
    Join Date
    03-31-2013
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    33

    Download Attachment and Rename With Subject Line v2

    I saw the old thread, linked here http://www.excelforum.com/outlook-pr...ject-line.html but am wondering a different question (complete newb to VBA)...

    Please Login or Register  to view this content.
    This is the code I pasted in, but now I am trying to actually run the VBA against a series of emails - But am getting a Run-time error '4'4': Object Required notification for this line of code:

    Please Login or Register  to view this content.
    What is this supposed to be?
    Last edited by CBJason; 05-02-2014 at 12:39 PM.

  2. #2
    Registered User
    Join Date
    03-31-2013
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    33

    Re: Download Attachment and Rename With Subject Line v2

    Added note - I am in a subfolder of my inbox called "Reports" in an Exchange environment...I did add a line to map to that folder as follows:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: Download Attachment and Rename With Subject Line v2

    Where the first line has this format you have to call it and pass something, in this case a MailItem.

    Sub Download_attachments_Sent_by_me2me(MyMail As MailItem)

    Run this once you select one or more MailItems.

    Please Login or Register  to view this content.
    Untested so see here if the above does not work. http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
    To mark "Solved" go to Thread Tools.

+ 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] Download attachment and rename with subject line
    By ali84pk in forum Outlook Programming / VBA / Macros
    Replies: 9
    Last Post: 03-10-2015, 11:32 AM
  2. Button to add attachment based on text in subject
    By Matei in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 09-24-2013, 09:27 AM
  3. [SOLVED] Macro to Rename Outlook Attachment Same as Email Subject
    By sandy_314 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2013, 09:59 AM
  4. Save attachment with specific subject
    By souljive99 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2011, 11:00 AM
  5. Emailing an attachment where the subject = data in cells
    By morris5984 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2008, 12:40 PM

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