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]

On Fri, Aug 2, 2013 at 2:18 PM,  <hambergcfa at gmail.com> wrote:
> On Thursday, August 1, 2013 2:32:55 PM UTC-4, Chris Angelico wrote:
> On Thu, Aug 1, 2013 at 7:08 PM,  <hambergcfa at gmail.com> wrote:
>
> 1) You receive an email
>
> 2) That email has two URLs in it ("secure hyperlinks" means they begin
>
> https:// ?)
>
> 3) You choose one of them as being "appropriate" - is it always the second?
>
> 4) You download the document at that URL, which requires a password
>
> 5) You then run some sort of alteration on the resulting CSV file.
>
> Please correct me on anything I've misunderstood.
>
> Python can certainly do all of these steps, with the possible
>
> exception of fetching the email. Dividing the problem up into separate
>
> steps will make the solving of it easier.
>
> ChrisA
>
> Thanks a lot ChrisA!  You are correct with everything except that the login hyperlink is always the first link and the second one is the link to register.
>
> Okay!
>
> Digression: You seem to be using Google Groups. Please read
>
> http://wiki.python.org/moin/GoogleGroupsPython before posting further,
>
> to avoid antagonizing the list's best responders.)
>
> The first step is to figure out how to retrieve the email. You may
>
> want to tweak your setup to make this easier. The next thing I'd do
>
> would be to port the macro to Python. Everything in between is fairly
>
> easy.
>
> ChrisA
>
> Thanks for the heads up ChrisA!  How should I tweak my setup to make it easier to retrieve my email?  I hope I'm doing this reply correctly.
> --
> http://mail.python.org/mailman/listinfo/python-list

Reading outlook email, I found this:

http://timgolden.me.uk/python/win32_how_do_i/read-my-outlook-inbox.html

There is lots to find via google with 'reading outlook email with python'

-- 
Joel Goldstick
http://joelgoldstick.com