I wanted to automate the process of email ID creation, automate email sending from web interface, automate auto login and sending email in google. I searched internet and found a wonderful tool called iMacro as a plugin in firefox.

iMacro is simply cool. It save me a few hundred bucks i would have paid the data entry people.

I automated my automatic email sending macro. Which would log into different gmail ids send 499 emails then logout and then login in a different gmail id and again send 499 email and so on. The program takes data from an csv file which stores the usernames passwords, and the recipent email ids.

Just so a simple search for macro in firefox and add the plugin. Then before starting the process click the record button and do the complete process once. Click stop recording.  Then edit the macro and add the input file location and use the column number in the places needed. The click play button and enjoy.

See my sample code below for login and email sending using google apps.

VERSION BUILD=7021019 RECORDER=FX
TAB T=1
‘ Specify input file (if !COL variables are used, IIM automatically assume a CSV format of the input file
‘CSV = Comma Separated Values in each line of the file
CMDLINE !DATASOURCE itimgulbarga_usa_orignal.csv
‘Number of columns in the CSV file. This must be accurate!
SET !DATASOURCE_COLUMNS 5
‘Start at line 2 to skip the header in the file
SET !LOOP 100
‘Increase the current position in the file with each loop
SET !DATASOURCE_LINE {{!LOOP}}
‘ Fill web form
URL GOTO=https://www.google.com/a/itimgulbarga.com/ServiceLogin?service=mail&passive=true&rm=false&continue=https%3A%2F%2Fmail.google.com%2Fa%2Fitimgulbarga.com%2F&bsv=1eic6yu9oa4y3&ss=1&ltmpl=default&ltmplcache=2&hl=en
TAG POS=1 TYPE=INPUT:TEXT FORM=ACTION:https://www.google.com/a/itimgulbarga.com/LoginAction2?service=mail ATTR=ID:Email CONTENT={{!COL1}}
SET !ENCRYPTION NO
TAG POS=1 TYPE=INPUT:PASSWORD FORM=ACTION:https://www.google.com/a/itimgulbarga.com/LoginAction2?service=mail ATTR=ID:Passwd CONTENT={{!COL2}}
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ID:gaia_loginform ATTR=ID:signIn
‘FRAME F=4
‘TAG POS=1 TYPE=A ATTR=TXT:basic<SP>HTML
TAG POS=1 TYPE=A ATTR=TXT:Compose<SP>Mail
TAG POS=1 TYPE=TEXTAREA FORM=NAME:f ATTR=ID:to CONTENT={{!COL5}},[email protected]
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:f ATTR=NAME:subject CONTENT={{!COL3}}
TAG POS=1 TYPE=TEXTAREA FORM=NAME:f ATTR=NAME:body CONTENT={{!COL4}}
TAG POS=2 TYPE=INPUT:SUBMIT FORM=NAME:f ATTR=NAME:nvp_bu_send&&VALUE:Send
TAG POS=1 TYPE=A ATTR=TXT:Sign<SP>out