import imaplib
import email
import re
import _mssql

conn = _mssql.connect(server='name', user='user', password='pw', database='db')

m = imaplib.IMAP4_SSL("imap.gmail.com", 993)
m.login("user","pw")
m.select('"Fire_Dispatch"')

result, data = m.search(None, "ALL") # search all email and return uids
if result == 'OK':
    for num in data[0].split():
        result, data = m.fetch(num,"(BODY[TEXT])")
        if result == 'OK':
            email_message = email.message_from_string(data[0][1].decode('utf-8'))    # raw email text including headers
p = str(email_message)
a = re.search("ALLCFD(.*)",p)

t =  (a.groups(1))


conn = _mssql.connect(server='localhost', user='username', password='password', database='db name')

conn.execute_non_query("INSERT INTO calls (call_date_time,call)VALUES(123,'t')")


m.close()
m.logout()