Skip to main content

Python script to mail merge with CC

Limitation of normal mail merge is that you can't insert Cc/Bcc fields into it. I have tried to overcome this by writing a small script. The script takes the recipients in To and recipients in Cc fields from an excel sheet. It reads the sheet one by one from both columns and send them emails reading on the contents from an external fields. Yes, it's simple, but what I was trying earlier was something else. I was trying to send 'personalized' emails with 'Cc' field in the mail. But the 'personalized' part is very difficult to implement, as I was not able to write the variable data to the body of the email. So, settled down with this fixed body contents being read from external file. Let me know if anybody is aware of how to send personalized body contents to respective users. I mean the some fields in the body of the mail should on user basis. In this case the body of the mail is general and fixed in nature.

Code to read user lists from excel and send the email inserting Cc field:

import smtplib
import sys
import xlrd
from email.mime.text import MIMEText

def SendEmail(emailTo,CCname):

        # Open the file to read the contents           
        fp = open('C:\.......\mailcontents.txt', 'rb')  
        msg = MIMEText(fp.read())
        fp.close()
       
        #pouplate the msg container fields
        msg['Subject']= "Test mail!"
        msg['From']='myslef@abcorg.com'
        msg['To']=emailTo
        msg['Cc']=CCname
       
              
        # finally send the email
        s = smtplib.SMTP('smtp.abcorg.com')
        s.sendmail(msg['From'], [emailTo,CCname], msg.as_string())
        s.quit() 



# Open the excelsheet containing mail records such as, To, CC
wb=xlrd.open_workbook ('C:\......\mailRecord.xlsx')
wb.sheet_names()
sh=wb.sheet_by_index(0)
for rownum in range(sh.nrows):
        emailTo=str(sh.cell(rownum,0).value)   # The To field in first coloumn
        CCname=str(sh.cell(rownum,1).value)  #The CC field in second coloumn
        SendEmail(emailTo,CCname)  # Call the function above

Comments

Ritesh said…
Hi Nilesh! Hope you're well. For sending personalised emails you can also do what marketing folks have been doing for ages, use the Mail Merge feature in Microsoft Office. Here's some documentation for Office 2003.

http://office.microsoft.com/en-us/word-help/word-mail-merge-a-walk-through-the-process-HA001034920.aspx
October 1, 2012 at 12:13 PM
Post a Comment

Popular posts from this blog

Breaking Excel password protection

If you came across an excel sheet asking for password for allowing to make any changes into it, you may want to unprotect it. All we need to do is to edit the xml file which comes intrinsically packaged with Excel 2007 or 2010. But what about Excel 2003? For that, open the Excel 2003 file within Excel 2007, save it as xlsx file. So, keep in mind all the Excel files below 2007 version, you need to convert them as Excel 2007 with extension .xlsx. Now here are the steps for doing that: 1. Open the Excel 2003 file (e.g. Secret.xlsx) and save it as .xlsx (Excel 2007) format. If you already have Excel 2007 file, then no need for any conversion. 2. Now change the extension of the above file to .zip and extract the zipped file. Browse through the file in the extracted folder and go to: <LocalPath>\Secret\xl\worksheets.   3. Now open the sheet/ sheets you want to remove protection in any xml editor. Look for keywords such as 'sheetProtection' or 'workbo...
10 comments
Read more

File Upload through Null Byte Injection

Sometimes, during file upload we come across situation wherein there would be check on the file extension at the client side as well as server side too. If the application does allow only .jpeg extension to be uploaded, the client side java script checks for the extension of the file before passing the request. We all know that how easily this can be defeated. Some applications, checks for the extension at the server side also. That's not easy to bypass. However there are some ways with which it still can be bypassed. Most of server side scripts are written in high level languages such as Php, Java etc who still use some C/C++ libraries to read the file name and contents. That leads to the problem. In C/C++ a line ends with /00 or which is called Null Byte. So whenever the interpreter sees a null byte at the end of the a string, it stops reading thinking it has reached at the end of the string. This can be used for the bypass. It works for many servers, specially php servers. T...
1 comment
Read more

jtool - an alternative to otool

jtool comes with a capability of running on Linux environment. Some ipa scanning tools are created to run on Linux environment where mac environment is not available. In such cases tools such as otool and class-dump-z will not work. So jtool can be an alternative to otool. For more information on jtool please refer to http://www.newosxbook.com/tools/jtool.html . It lists down various commands which have same output as otool or a equivalent. There are several commands mentioned in link. But for our customized requirements and basis checks I have listed down the below ones after running on many binaries. The outputs are similar or equivalent to otool and class-dump-z: Commands for checking PIE flag (ASLR) in jTool jtool -d -v -arch | grep stack ·           Automatic Reference Counting (ARC) protection: jtool -d -v -arch | grep _objc_release ·           To check if the devic...
1 comment
Read more