{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["email Sender","Email Designer"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"email Sender","index":0,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,10,4,11],[3,7,3,8],[6,8,7,8],[6,1,6,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[2,7,2,8],[1,6,1,8]]}
[]
[null,null,null,null,null,null,"Recommended Articles and Pages",null,null,null,"\n\n1. Using this Tool you can send unlimited number of individual emails.\n2. You can input CC, BCC IDs and Attachment as well.\n3. Allthe emails sent SUCCESSFULLY will remain in white background color.\n4. All the emails which are FAILED, will be marked in RED Background Color.\n5. Number of Successfull and Failed Email Sent will be displayed at the end."]
[null,null,null,null,null,null,null,"Beginner’s Page: Excel Macro Tutorial"]
[null,null,null,null,null,null,null,"Tools: Excel Macro Tools – FREE Download"]
[null,null,9,0]
[]
[null,"Email Ids   (Multiple Ids separated with \";\")",null,null,"Subject","Email Body\n(You can write your body in HTML or format it in Excel Cell)","Error Description","Select cell and click to attach. Select multiple files by pressing CTRL Key","#attachments"]
[null,"To*","CC","BCC"]
[0,"vishwamitra01@gmail.com;vishwamitra02@gmail.com",null,null,"Mail formatted in Excel Cell","Dear Sir,\nThis line is written in RED Color Font. I want to BOLD and Italics this line in Black Color.\n\nRegards,\nVishwa",null,"C:\\Users\\vmishra\\Desktop\\project.xml\nC:\\Users\\vmishra\\Desktop\\3-PreScore-Verification1.xml",{"$f":"IF(LEN(H9)=0,0,LEN(H9)-LEN(SUBSTITUTE(H9,CHAR(10),\"\"))+1)","v":2}]
[0,"vishwamitra01@gmail.com",null,null,"Mail with HTML Code","<html><b>Hello Friends<br/> <i>This line is in italics</i><b>This line is in bold</b><br/>This is going to be in Next Line.<br/><b>Regards,<br/>Vishwa</html>",null,"C:\\Users\\vmishra\\Desktop\\Case1-Dossier.xml\nC:\\Users\\vmishra\\Desktop\\Case2-Dossier.xml",{"$f":"IF(LEN(H10)=0,0,LEN(H10)-LEN(SUBSTITUTE(H10,CHAR(10),\"\"))+1)","v":2}]
[0,"vishwamitra01@gmail.com",null,null,"Mixture of HTML code and Formatted in Cell","This is formatted in Cell. Below part is in HTML coding.\n<html><b>Hello Friends<br/> <i>This line is in italics</i><b>This line is in bold</b><br/>This is going to be in Next Line.<br/><b>Regards,<br/>Vishwa</html>",null,null,0]
[0,"vishwamitra01@gmail.com",null,null,"Mail with Image and Text Written","Dear Reader,\nPlease find screen shot of my add in:\n<html><body><img src=\"D:\\Documents and Settings\\vish\\Desktop\\logo.bmp\"></body></html><br/>Regards,\nVishwa",null,null,0]
[0,"vishwamitra01@gmail.com",null,null,"Your Bonus - Year 2016-2017","Dear James,\n\nCongratulations !!\nIn recognition of your performance and contribution to the orgnization during the appraisal period 2016-2017, you are eligible to receive a bonus of $5000.00which is 70.0 %of your CTC. \n\nOnce again congratulations and keep up the Good work !!\n\nRegards,\nBond,\nHR Department",null,null,0]
[0,"vishwamitra01@gmail.com",null,null,"Your Bonus - Year 2016-2017","Dear Michal,\n\nCongratulations !!\nIn recognition of your performance and contribution to the orgnization during the appraisal period 2016-2017, you are eligible to receive a bonus of $6000.00which is 80.0 %of your CTC. \n\nOnce again congratulations and keep up the Good work !!\n\nRegards,\nBond,\nHR Department",null,"C:\\Users\\vmishra\\Desktop\\AX.xml",1]
[0,"vishwamitra01@gmail.com",null,null,"Your Bonus - Year 2016-2017","Dear Sanjay,\n\nCongratulations !!\nIn recognition of your performance and contribution to the orgnization during the appraisal period 2016-2017, you are eligible to receive a bonus of $5400.00which is 65.0 %of your CTC. \n\nOnce again congratulations and keep up the Good work !!\n\nRegards,\nBond,\nHR Department",null,null,0]
[0,"vishwamitra01@gmail.com",null,null,"Your Bonus - Year 2016-2017","Dear Kestro,\n\nCongratulations !!\nIn recognition of your performance and contribution to the orgnization during the appraisal period 2016-2017, you are eligible to receive a bonus of $7100.00which is 75.0 %of your CTC. \n\nOnce again congratulations and keep up the Good work !!\n\nRegards,\nBond,\nHR Department",null,null,0]
[0,"vishwamitra01@gmail.com",null,null,"Your Bonus - Year 2016-2017","Dear Vincent,\n\nCongratulations !!\nIn recognition of your performance and contribution to the orgnization during the appraisal period 2016-2017, you are eligible to receive a bonus of $6400.00which is 75.0 %of your CTC. \n\nOnce again congratulations and keep up the Good work !!\n\nRegards,\nBond,\nHR Department",null,"C:\\Users\\vmishra\\Desktop\\Case3-Dossier.xml\nC:\\Users\\vmishra\\Desktop\\Case1-Dossier.xml\nC:\\Users\\vmishra\\Desktop\\CLIC-DEMO-soapui-project1.xml",3]

{"sheet":"Email Designer","index":1,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,3,3,5],[2,2,3,2],[4,3,12,5],[15,1,15,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,7,16,7],[15,8,16,8],[15,9,16,9],[15,10,16,10]]}
[]
[]
[null,null,"Your Fixed Input","Using formula, a sample is generated based on your input. \n<You are free to change the formula, based on your need>"]
[]
[null,"Generic addressing Word","Dear",{"$f":"$C$5 & \" \" &G18 & \",\" & CHAR(10) &  CHAR(10) & $C$6 & \" \" &TEXT(H18,\"$0.00\") & $C$7 & \" \" & TEXT(I18,\"0.0 %\") & $C$8 & CHAR(10)& CHAR(10) & $C$13","v":"Dear James,Congratulations !!In recognition of your performance and contribution to the orgnization during the appraisal period 2016-2017, you are eligible to receive a bonus of $5000.00which is 70.0 %of your CTC. Once again congratulations and keep up the Good work !!Regards,Bond,HR Department"}]
[null,"Generic Mail Body 1","Congratulations !!\nIn recognition of your performance and contribution to the orgnization during the appraisal period 2016-2017, you are eligible to receive a bonus of"]
[null,"Generic Mail Body 2","which is"]
[null,"Generic Mail Body 3","of your CTC. \n\nOnce again congratulations and keep up the Good work !!"]
[null,"Generic Mail Body 4"]
[null,"Generic Mail Body 5"]
[null,"Generic Mail Body 6"]
[null,"Generic Mail Body 7"]
[null,"Signature","Regards,\nBond,\nHR Department"]
[]
[]
[null,"Email Ids   (Multiple Ids separated with \";\")",null,null,"Subject","Email Body\n(You can write your body in HTML or format it in Excel Cell)","Name (Reciever's Name (To))","Specific Data 1","Specific Data 2","Specific Data 3","Specific Data 4"]
[null,"To*","CC","BCC"]
["--->","James@james.com",null,null,"Your Bonus - Year 2016-2017",{"$f":"$C$5 & \" \" &G18 & \",\" & CHAR(10) &  CHAR(10) & $C$6 & \" \" &TEXT(H18,\"$0.00\") & $C$7 & \" \" & TEXT(I18,\"0.0 %\") & $C$8 & CHAR(10)& CHAR(10) & $C$13","v":"Dear James,Congratulations !!In recognition of your performance and contribution to the orgnization during the appraisal period 2016-2017, you are eligible to receive a bonus of $5000.00which is 70.0 %of your CTC. Once again congratulations and keep up the Good work !!Regards,Bond,HR Department"},"James",5000,0.7]
[null,"Michal@Michal.com",null,null,"Your Bonus - Year 2016-2017",{"$f":"$C$5 & \" \" &G19 & \",\" & CHAR(10) &  CHAR(10) & $C$6 & \" \" &TEXT(H19,\"$0.00\") & $C$7 & \" \" & TEXT(I19,\"0.0 %\") & $C$8 & CHAR(10)& CHAR(10) & $C$13","v":"Dear Michal,Congratulations !!In recognition of your performance and contribution to the orgnization during the appraisal period 2016-2017, you are eligible to receive a bonus of $6000.00which is 80.0 %of your CTC. Once again congratulations and keep up the Good work !!Regards,Bond,HR Department"},"Michal",6000,0.8]
[null,"Sanjay@sanjay.com",null,null,"Your Bonus - Year 2016-2017",{"$f":"$C$5 & \" \" &G20 & \",\" & CHAR(10) &  CHAR(10) & $C$6 & \" \" &TEXT(H20,\"$0.00\") & $C$7 & \" \" & TEXT(I20,\"0.0 %\") & $C$8 & CHAR(10)& CHAR(10) & $C$13","v":"Dear Sanjay,Congratulations !!In recognition of your performance and contribution to the orgnization during the appraisal period 2016-2017, you are eligible to receive a bonus of $5400.00which is 65.0 %of your CTC. Once again congratulations and keep up the Good work !!Regards,Bond,HR Department"},"Sanjay",5400,0.65]
[null,"Kestro@Kestro.com",null,null,"Your Bonus - Year 2016-2017",{"$f":"$C$5 & \" \" &G21 & \",\" & CHAR(10) &  CHAR(10) & $C$6 & \" \" &TEXT(H21,\"$0.00\") & $C$7 & \" \" & TEXT(I21,\"0.0 %\") & $C$8 & CHAR(10)& CHAR(10) & $C$13","v":"Dear Maria,Congratulations !!In recognition of your performance and contribution to the orgnization during the appraisal period 2016-2017, you are eligible to receive a bonus of $7100.00which is 75.0 %of your CTC. Once again congratulations and keep up the Good work !!Regards,Bond,HR Department"},"Maria",7100,0.75]
[null,"Vincent@vincent.com",null,null,"Your Bonus - Year 2016-2017",{"$f":"$C$5 & \" \" &G22 & \",\" & CHAR(10) &  CHAR(10) & $C$6 & \" \" &TEXT(H22,\"$0.00\") & $C$7 & \" \" & TEXT(I22,\"0.0 %\") & $C$8 & CHAR(10)& CHAR(10) & $C$13","v":"Dear Vincent,Congratulations !!In recognition of your performance and contribution to the orgnization during the appraisal period 2016-2017, you are eligible to receive a bonus of $6400.00which is 75.0 %of your CTC. Once again congratulations and keep up the Good work !!Regards,Bond,HR Department"},"Vincent",6400,0.75]