{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Help","Mail Contents","Mail List","Settings"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":1,"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":"Help","index":0,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,9,0,10],[8,3,8,11],[9,3,9,11],[13,1,13,6],[16,1,16,6]]}
[null,null,null,null,null,null,null,null,null,"Version 1.3.0",null,"ⓒXLWorks"]
[null,"How to send mail from Excel with Microsoft Outlook"]
[]
[null,"How to send mail when Microsoft Outlook is installed on your PC."]
[null,"You can send mail in the following order."]
[]
[null,"Sheet Name",null,"Description"]
[]
[null,"Mail Contents",null,"1) Enter subject  and  body of the Mail.  If you enter {1}, {2} in the mail subject or mail body, this VBA program replaces {1}, {2} with the replacement value in the \"Mail List\" sheet.\n\n2) If required, select options."]
[null,"Mail List",null,"3) Enter email address of the recipient and attachement file name with folder name.\n\n4) Click \"Send Mail\" button on the ribbon menu \"Mail from Excel\" tab to send mail from Excel.\n* If you want to check the contents of the mail before sending it, click the \"Preview before sending\" button"]
[]
[]
[null,"Contact"]
[null,"http://www.xlworks.net"]
[]
[null,"This file was created by modifying the material published on the site below."]
[null,"http://www.rondebruin.nl/win/section1.htm"]

{"sheet":"Mail Contents","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Enter the subject and body of the message and, if necessary, select the option Delivery confirmation / Request read receipt / Signing."]
[null,"Subject","About Overvdue ${6}."]
[null,"Mail body ","Dear {5}, <br>\r\nYour are now overdue ${6}. <br>\r\nPlease make a deposit to the following account immediately. <br>\r\nAccount number: {7} <br>\n<br>\nSincerely,<br>\nJohn",null,"You can use HTML tags in your mail body.\n\nLine breaks: <br>\nBold text: <b> Content ... </ b>\n\n"]
[null,"Request a Delivery Request","NO",null,"If you select \"YES\", you will receive a message that the mail has been delivered."]
[null,"Request a Read Receipt","NO",null,"If you select \"YES\", you will receive an email asking if the user has read your mail."]
[null,"Use Signature","YES",null,"Select \"YES\" to use the signature set in Outlook."]
[null,"Specify mail body font","YES",null,"Select \"YES\" if you want the font specified below to be specified as the font of the mail body"]
[null,"Mail body font type and size"]
[null,"Delay Delivery\nDo not deliver before :",null,null,"\"Enter the time in the form\" \"2017-11-06 23:30\" \""]
[]
[null,"Example Results"]
[null,"If you type like this, {4}, {5} ... Sends the mail by replacing the part you entered with the value of the field in the \"Mail List\" sheet."]
[null,"Subject","About Overvdue {6}"]
[null,"Mail body ","Dear Smith, \nYour are now overdue $150. \nPlease make a deposit to the following account immediately. \nAccount number: 226-3213313 \n\nSincerely,\nJohn\n"]

{"sheet":"Mail List","index":2,"n_rows":4,"n_cols":46,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Whether to send\n(YES or No)","Recipient Mail (TO)\n{1}","Carbon Copy\n(CC)\n{2}","Blind Carbon Copy\n(BCC)\n{3}","Value to replace\n{4}","Value to replace\n{5}","Value to replace\n{6}","Value to replace\n{7}","Value to replace\n{8}","Value to replace\n{9}","Value to replace\n{10}","Value to replace\n{11}","Value to replace\n{12}","Value to replace\n{13}","Value to replace\n{14}","Value to replace\n{15}","Value to replace\n{16}","Value to replace\n{17}","Value to replace\n{18}","Value to replace\n{19}","Value to replace\n{20}","Value to replace\n{21}","Value to replace\n{22}","Value to replace\n{23}","Value to replace\n{24}","Value to replace\n{25}","File name of \nAttachment 1","File name of \nAttachment 2","File name of \nAttachment 3","File name of \nAttachment 4","File name of \nAttachment 5","File name of \nAttachment 6","File name of \nAttachment 7","File name of \nAttachment 8","File name of \nAttachment 9","File name of \nAttachment 10","File name of \nAttachment 11","File name of \nAttachment 12","File name of \nAttachment 13","File name of \nAttachment 14","File name of \nAttachment 15","File name of \nAttachment 16","File name of \nAttachment 17","File name of \nAttachment 18","File name of \nAttachment 19","File name of \nAttachment 20"]
["YES","smith@aaa.com",null,null,"Bravo Systems","Smith",150,"226-3213313",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c:\\temp\\New Text Document.txt"]
["YES","elsa@aaa.com",null,null,"Bravo Systems","Elsa",100,"226-3213314",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c:\\temp\\New Text Document.txt"]
["YES","peter@aaa.com",null,null,"Bravo Systems","Peter",200,"226-3213315",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c:\\temp\\New Text Document.txt"]

{"sheet":"Settings","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Settings"]
["If you have changed the settings, you must close this file and reopen this file for the changes to take effect."]
["Setting item","Value","Remarks"]
["Mail contents sheet name","Mail Contents"]
["Mail Recipient List sheet name","Mail List"]
["\"Value to replace\" setting end column","Z","Columns A through D are not assignable, and the start column is fixed at B"]
["\"File name of attachment\" setting start column","AA","You can specify a value only after the \"Value to replace\" setting end column."]
["\"File name of attachment\" setting end column","AT","You can specify a value only after the \"Value to replace\" setting end column."]