Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #51754

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

Show all headers | View raw

On Thu, Aug 1, 2013 at 7:08 PM,  <hambergcfa@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

Back to comp.lang.python | Previous | Next — Previous in thread | 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