Apache OpenOffice Community Forum

Code: Select all

#!/usr/bin/python
# -*- coding: UTF-8 -*-

import smtplib
## Added to allow use of sleep() ##
import time
## End added for sleep() ##
from email.mime.text import MIMEText

########### SMTP-Settings ##############################
gSMTP = "securesmtp.example.com"
gSMTPport = 587
gSender = "myself@example.com"
gUser = gSender #or whatever log-in name
gPasswort = "secret"
########################################################

def getServer():
    server = smtplib.SMTP(gSMTP, gSMTPport)
    server.ehlo()
    server.starttls()
    server.ehlo()
    server.login(gUser, gPasswort)
    return server

def composeMail(addr, subj, body):
    mail = MIMEText(body)
    mail['From'] = gSender
    mail['Subject'] = subj
    mail['To'] = addr
    return mail
    

def sendMailsFromRangeSelection():
    doc = XSCRIPTCONTEXT.getDocument()
    sel = doc.getCurrentSelection()
    try:
        da = sel.getDataArray()
    except:
        raise('Select a sheet cell range with 3 columns for receipient, subject body in that order')
        return
    try:
        server = getServer()
    except:
        raise('Sever connection failed')
    else:
        for arow in da:
            mail = composeMail(arow[0], arow[1], arow[2])
            server.sendmail(gSender, arow[0], mail.as_string())
            sleep(5)  ## Add 5 second delay between emails ##
    server.quit()

g_exportedScripts = sendMailsFromRangeSelection,