On Thursday, August 1, 2013 1:47:37 PM UTC-4, Chris Angelico wrote:
> On Thu, Aug 1, 2013 at 6:31 PM, <hamberg...@gmail.com> wrote:
>
> > 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.
>
>
>
> Okay, taking a few steps back here.
>
>
>
> 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.
--
http://mail.python.org/mailman/listinfo/python-list
