Databases
StackOverflow2013
Postsdbo
POpython imaplib to get gmail inbox subjects titles and sender name
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POpython imaplib to get gmail inbox subjects titles and sender name
    primarykey
    data
    text
    <p>I'm using pythons imaplib to connect to my gmail account. I want to retrieve the top 15 messages (unread or read, it doesn't matter) and display just the subjects and sender name (or address) but don't know how to display the contents of the inbox.</p> <p>Here is my code so far (successful connection)</p> <pre><code>import imaplib mail = imaplib.IMAP4_SSL('imap.gmail.com') mail.login('mygmail@gmail.com', 'somecrazypassword') mail.list() mail.select('inbox') #need to add some stuff in here mail.logout() </code></pre> <p>I believe this should be simple enough, I'm just not familiar enough with the commands for the imaplib library. Any help would be must appreciated...</p> <p><strong>UPDATE</strong> thanks to Julian I can iterate through each message and retrieve the entire contents with: </p> <pre><code>typ, data = mail.search(None, 'ALL') for num in data[0].split(): typ, data = mail.fetch(num, '(RFC822)') print 'Message %s\n%s\n' % (num, data[0][1]) mail.close() </code></pre> <p>but I'm wanting just the subject and the sender. Is there a imaplib command for these items or will I have to parse the entire contents of data[0][1] for the text: Subject, and Sender?</p> <p><strong>UPDATE</strong> OK, got the subject and sender part working but the iteration (1, 15) is done by desc order apparently showing me the oldest messages first. How can I change this? I tried doing this:</p> <pre><code>for i in range( len(data[0])-15, len(data[0]) ): print data </code></pre> <p>but that just gives me <code>None</code> for all 15 iterations... any ideas? I've also tried <code>mail.sort('REVERSE DATE', 'UTF-8', 'ALL')</code> but gmail doesnt support the .sort() function</p> <p><strong>UPDATE</strong> Figured out a way to do it: </p> <pre><code>#....^other code is the same as above except need to import email module mail.select('inbox') typ, data = mail.search(None, 'ALL') ids = data[0] id_list = ids.split() #get the most recent email id latest_email_id = int( id_list[-1] ) #iterate through 15 messages in decending order starting with latest_email_id #the '-1' dictates reverse looping order for i in range( latest_email_id, latest_email_id-15, -1 ): typ, data = mail.fetch( i, '(RFC822)' ) for response_part in data: if isinstance(response_part, tuple): msg = email.message_from_string(response_part[1]) varSubject = msg['subject'] varFrom = msg['from'] #remove the brackets around the sender email address varFrom = varFrom.replace('&lt;', '') varFrom = varFrom.replace('&gt;', '') #add ellipsis (...) if subject length is greater than 35 characters if len( varSubject ) &gt; 35: varSubject = varSubject[0:32] + '...' print '[' + varFrom.split()[-1] + '] ' + varSubject </code></pre> <p>this gives me the most recent 15 message subject and sender address in decending order as requested! Thanks to all who helped!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGilles
    1. USsadmicrowave
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POpython imaplib to get gmail inbox subjects titles and sender name
      1. USErfankam
      1. VTFavorite
    2. VO
      singulars
      1. POpython imaplib to get gmail inbox subjects titles and sender name
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POpython imaplib to get gmail inbox subjects titles and sender name
      1. USjonathanmarvens
      1. VTFavorite
    1. COThe example from the Python docs works fine for me: http://docs.python.org/library/imaplib#imap4-example
      singulars
      1. POpython imaplib to get gmail inbox subjects titles and sender name
      1. USJulian
    2. COYes, your are right, that does work quiet well for retrieving full message content of all messages. I just want the subject and the sender address though. I can then make the for loop just 1 through 15
      singulars
      1. POpython imaplib to get gmail inbox subjects titles and sender name
      1. USsadmicrowave
    3. COAnd another link to the Python docs: http://docs.python.org/library/email.html ;)
      singulars
      1. POpython imaplib to get gmail inbox subjects titles and sender name
      1. USJulian
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload