Path: csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.002 X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; 'python.': 0.02; 'resulting': 0.04; 'subject:password': 0.05; 'subject:Python': 0.06; 'subject:file': 0.07; 'subject:How': 0.10; 'cc:addr:python- list': 0.11; 'python': 0.11; 'csv': 0.16; 'easier.': 0.16; 'hyperlink': 0.16; 'steps,': 0.16; 'subject: \n ': 0.16; 'subject:Outlook': 0.16; 'subject:download': 0.16; 'subject:folder': 0.16; 'subject:login': 0.16; 'subject:run': 0.16; 'tweak': 0.16; 'url:timgolden': 0.16; 'exception': 0.16; 'thursday,': 0.16; 'wrote:': 0.18; 'thu,': 0.19; 'outlook': 0.22; 'aug': 0.22; 'separate': 0.22; 'cc:addr:python.org': 0.22; 'certainly': 0.24; 'subject: .': 0.24; 'url:moin': 0.24; 'fairly': 0.24; 'file.': 0.24; 'cc:2**0': 0.24; 'login': 0.25; 'sort': 0.25; "i've": 0.25; 'this:': 0.26; 'second': 0.26; 'header:In-Reply- To:1': 0.27; 'correct': 0.29; 'chris': 0.29; 'subject:) ': 0.29; 'message-id:@mail.gmail.com': 0.30; "i'm": 0.30; 'url:mailman': 0.30; 'easier': 0.31; 'posting': 0.31; 'url:wiki': 0.31; 'correctly.': 0.31; 'figure': 0.32; 'run': 0.32; 'url:python': 0.33; 'fri,': 0.33; 'subject:the': 0.34; "i'd": 0.34; 'problem': 0.35; 'except': 0.35; 'received:google.com': 0.35; 'google': 0.35; 'there': 0.35; 'url:listinfo': 0.36; 'doing': 0.36; 'next': 0.36; 'thanks': 0.36; 'possible': 0.36; 'url:org': 0.36; 'should': 0.36; 'two': 0.37; 'step': 0.37; 'being': 0.38; 'solving': 0.38; 'pm,': 0.38; 'anything': 0.39; 'url:mail': 0.40; 'how': 0.40; 'read': 0.60; 'email?': 0.60; 'hope': 0.61; 'august': 0.61; 'first': 0.61; 'choose': 0.64; 'to:addr:gmail.com': 0.65; 'reply': 0.66; 'between': 0.67; 'email,': 0.69; 'url:me': 0.69; 'receive': 0.70; 'further,': 0.74; 'groups.': 0.74; 'joel': 0.91; '2013': 0.98 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=wmgPxe8QMvlNZriKtHaWsqroxgagvJFyW+8ow4b3VTE=; b=lWCN4dICDOnCmEkgVfoYh4SQ+pPw2yiNk8BUDsiWIFzOx64E56uyy/5ttQeUoD4xL5 S/YqjXWQ8+QpSvtBWO4I0qqrjfsJIAFASGO0hR0YnzGxP427D3mj5wigBXSig2xshezp L7IpblrUP3YFtpm0sdrH7rDb4yUG8868aT/+DKN3avef7LhATPbrjIGtoDiAjL0U9yNL mkBOavgFatNZ9hlrCYRiUTYBa2IlNBCLjmuCuelfo7SZsJFpDPTw+UrC9Wppl2SUkPGX XvUAYuXZ6pmOqeBz4BCsbFyiXG2p3H/vB62aywJTS7xRvxNLHJuBS33Ip3i4pDglsg5L 6kug== MIME-Version: 1.0 X-Received: by 10.52.34.209 with SMTP id b17mr1337114vdj.111.1375469740133; Fri, 02 Aug 2013 11:55:40 -0700 (PDT) In-Reply-To: <54f5caea-6526-4f8f-808f-3da46824dc1d@googlegroups.com> References: <1d7bfd13-52d0-4d2b-8f7f-e117cdec2a5b@googlegroups.com> <54f5caea-6526-4f8f-808f-3da46824dc1d@googlegroups.com> Date: Fri, 2 Aug 2013 14:55:40 -0400 Subject: 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 From: Joel Goldstick To: hambergcfa@gmail.com Content-Type: text/plain; charset=UTF-8 Cc: "python-list@python.org" X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 59 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1375469743 news.xs4all.nl 15983 [2001:888:2000:d::a6]:57431 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:51821 On Fri, Aug 2, 2013 at 2:18 PM, wrote: > On Thursday, August 1, 2013 2:32:55 PM UTC-4, Chris Angelico wrote: > On Thu, Aug 1, 2013 at 7:08 PM, 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