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 at gmail.com]

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.