How to use Python to open Unread message(s) in specific Outlook folder, clicking a hyperlink within the email message to a secure login window, entering password to download .csv file, run Excel macro

Newsgroups	comp.lang.python
Date	2013-08-01 10:31 -0700
Message-ID	<1d7bfd13-52d0-4d2b-8f7f-e117cdec2a5b@googlegroups.com> (permalink)
Subject	How to use Python to open Unread message(s) in specific Outlook folder, clicking a hyperlink within the email message to a secure login window, entering password to download .csv file, run Excel macro
From	hambergcfa@gmail.com

Show all headers | View raw

Entire Project
I am very new to Python and realize my subject line is more than a mouthful and the best way to tackle this project may be to break it down into smaller projects; but I wanted to let you know what my entire project is in the event there is/are shortcuts or more reliable ways to go about what I'm trying to accomplish.

Details
Every morning I receive three emails (three different subject lines) in the same Sub-Folder ("POINT") under Folder ("Reports") in my Inbox in Outlook.  Each email has two secure hyperlinks, one provides me with a site to register and the other provides a window for me to enter my password to download a .csv file.

Is there code that will open the "Unread" emails in the "POINT" folder, click the appropriate hyperlink, enter my password (the same for all emails), and download the .csv file and then run an Excel macro?  I've already created the Excel macro, one for each of the different files I'm downloading.

I have no idea where to begin with Outlook and have reservations as to whether or not this is even possible.

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

How to use Python to open Unread message(s) in specific Outlook folder, clicking a hyperlink within the email message to a secure login window, entering password to download .csv file, run Excel macro hambergcfa@gmail.com - 2013-08-01 10:31 -0700
  Re: How to use Python to open Unread message(s) in specific Outlook folder, clicking a hyperlink within the email message to a secure login window, entering password to download .csv file, run Excel macro Chris Angelico <rosuav@gmail.com> - 2013-08-01 18:47 +0100
    Re: How to use Python to open Unread message(s) in specific Outlook folder, clicking a hyperlink within the email message to a secure login window, entering password to download .csv file, run Excel macro hambergcfa@gmail.com - 2013-08-01 11:08 -0700
      Re: How to use Python to open Unread message(s) in specific Outlook folder, clicking a hyperlink within the email message to a secure login window, entering password to download .csv file, run Excel macro Chris Angelico <rosuav@gmail.com> - 2013-08-01 19:32 +0100
        Re: How to use Python to open Unread message(s) in specific Outlook folder, clicking a hyperlink within the email message to a secure login window, entering password to download .csv file, run Excel macro hambergcfa@gmail.com - 2013-08-02 11:18 -0700
          Re: How to use Python to open Unread message(s) in specific Outlook folder, clicking a hyperlink within the email message to a secure login window, entering password to download .csv file, run Excel macro Joel Goldstick <joel.goldstick@gmail.com> - 2013-08-02 14:55 -0400
          Re: How to use Python to open Unread message(s) in specific Outlook folder, clicking a hyperlink within the email message to a secure login window, entering password to download .csv file, run Excel macro Skip Montanaro <skip@pobox.com> - 2013-08-02 14:25 -0500
          Re: How to use Python to open Unread message(s) in specific Outlook folder, clicking a hyperlink within the email message to a secure login window, entering password to download .csv file, run Excel macro Chris Angelico <rosuav@gmail.com> - 2013-08-02 23:30 +0100

csiph-web