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
--
http://mail.python.org/mailman/listinfo/python-list
