+ Reply to Thread
Results 1 to 2 of 2

Create macro to open daily email and Excel attachment from Outlook

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    Auckland
    MS-Off Ver
    Excel 2010
    Posts
    36

    Create macro to open daily email and Excel attachment from Outlook

    Hi there

    I got the following macro from here to go through my Outlook inbox and search for an email with a specific subject. Then with that take attachmnet and move it it a directory whilst also moving the email to another folder. So I finally got it to work.

    Please Login or Register  to view this content.

    Now I am looking at scheduling it to be done weekly. I thought this could be done via a vbs script with something like
    Please Login or Register  to view this content.
    taken from here, but I can't seem to get this to work. Can anyone advise if it can be done?

    I also done some other searching and there may also be a way by using a rule in outlook, but I have yet to find clear instructions on this. Appreciate any help!!

  2. #2
    Registered User
    Join Date
    07-17-2012
    Location
    Auckland
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Create macro to open daily email and Excel attachment from Outlook

    here helped me work out how to do it using a task item reminder.

    http://www.pcreview.co.uk/forums/sch...-t2537123.html

    I would still like to work out how to run the macro the other way
    Please Login or Register  to view this content.
    from an excel macro or vbs script for example. Help/pointers would be appreciated. tks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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