+ Reply to Thread
Results 1 to 2 of 2

VBA to autodownload Outlook attachments

  1. #1
    Registered User
    Join Date
    12-31-2013
    Location
    Here
    MS-Off Ver
    Excel 2010
    Posts
    21

    VBA to autodownload Outlook attachments

    Hi,

    I've tried to put together some code to autodownload .pdf attachments sent to me in Outlook. What I need is for the code to read the name of the attachment, and depending on that, change the folder where it'll save the file. For example:

    If the name of the file starts with "OT sheets", then save the file in "C:\Users\me\Desktop\OT Sheets CURRENT\"
    If the name of the file starts with "Week", then save the file in "C:\Users\me\Desktop\Graphs"

    etc.

    Here's the code I have so far (note that I only put this together by combing google - I don't really understand how it works)

    Please Login or Register  to view this content.
    But I get the error "Compile Error - Type Mismatch" with line 3 highlighted.

    Anyone know how to get this to work?

    Thanks
    Last edited by lawrence24; 08-11-2015 at 03:56 AM.

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

    Re: VBA to autodownload Outlook attachments

    I think you may be mixing in some non-VBA code.

    Please Login or Register  to view this content.
    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. Help On My Outlook Attachments
    By Don Adeks in forum Outlook Formatting & Functions
    Replies: 3
    Last Post: 06-09-2015, 04:14 AM
  2. Save Outlook Attachments
    By tejboyd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-17-2014, 01:05 PM
  3. User form to add attachments and send the form and attachments via outlook
    By scorchio83 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2013, 03:46 AM
  4. Sending Outlook Attachments with VBA
    By nms2130 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2011, 12:36 PM
  5. [SOLVED] opening zip outlook attachments
    By Rich in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2006, 05:20 AM
  6. Outlook Webmail and Attachments
    By Jane in forum Excel General
    Replies: 0
    Last Post: 10-12-2005, 02:05 PM
  7. Saving attachments from Outlook
    By Jamie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-17-2005, 03:06 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