{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["HC","Keys","Data","Hoja de control"],"not_rendered":{"images":3,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"HC","index":0,"n_rows":24,"n_cols":13,"rows_kept":24,"merged":[[3,9,3,12],[4,2,4,7],[5,10,5,12],[6,2,6,7],[8,2,14,7],[16,2,16,7],[20,2,20,7],[21,2,21,7],[22,2,22,7],[23,3,23,7]]}
[]
[null,"Bulk Email Sending"]
[null,"V1.1 - Daniel Zaldaña - danielzadana.com"]
[]
[null,"Main Email","Email in the first column in Data sheet",{"$nulls":6},"List of columns","KEY","Inserted in Subject?","Inserted in Body?"]
[{"$nulls":9},"Col1: Main Email","First column in Data sheet should always be the email"]
[null,"Subject","Notificación <<Nombre>>",{"$nulls":6},"Nombre","<<Nombre>>",{"$f":"IFERROR(IF(FIND(K7,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"YES"},{"$f":"IFERROR(IF(FIND(K7,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"YES"}]
[{"$nulls":9},"Monto","<<Monto>>",{"$f":"IFERROR(IF(FIND(K8,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"YES"},"YES"]
[null,"Mail Body","Good morning <<Nombre>>.\n\nI confirm the payment in concept of <<Concepto>> for a value of $ <<Monto>>.\n\nBR.\nDaniel Zaldaña",{"$nulls":6},"Fecha de corte","<<Fecha de corte>>",{"$f":"IFERROR(IF(FIND(K9,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"NO"},"NO"]
[{"$nulls":9},"Concepto","<<Concepto>>",{"$f":"IFERROR(IF(FIND(K10,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"YES"},"YES"]
[{"$nulls":10},"<<>>",{"$f":"IFERROR(IF(FIND(K11,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"NO"},"NO"]
[{"$nulls":10},"<<>>",{"$f":"IFERROR(IF(FIND(K12,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"NO"},"NO"]
[{"$nulls":10},"<<>>",{"$f":"IFERROR(IF(FIND(K13,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"NO"},"NO"]
[{"$nulls":10},"<<>>",{"$f":"IFERROR(IF(FIND(K14,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"NO"},"NO"]
[{"$nulls":10},"<<>>",{"$f":"IFERROR(IF(FIND(K15,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"NO"},"NO"]
[{"$nulls":10},"<<>>",{"$f":"IFERROR(IF(FIND(K16,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"NO"},"NO"]
[null,"HTML Signature","Not Enabled/Enter the signature in text format in the Body of the email",{"$nulls":7},"<<>>",{"$f":"IFERROR(IF(FIND(K17,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"NO"},"NO"]
[{"$nulls":10},"<<>>",{"$f":"IFERROR(IF(FIND(K18,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"NO"},"NO"]
[null,"Show Before Sending","NO",{"$nulls":7},"<<>>",{"$f":"IFERROR(IF(FIND(K19,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"NO"},"NO"]
[{"$nulls":10},"<<>>",{"$f":"IFERROR(IF(FIND(K20,$C$9)<>\"\",\"YES\",\"NO\"),\"NO\")","v":"NO"},"NO"]
[null,"Attached Files","Not Enabled/Attachments will not be sent"]
[null,"CC/BCC","Not Enabled/Copy or BCC emails will not be sent"]
[null,"Mail sending schedule","Not Enabled/Emails will be sent immediately"]
[null,"Límit",100]

{"sheet":"Keys","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"hidden":true}
[]
[null,"Mostrar antes de enviar"]
[null,"YES"]
[null,"NO"]

{"sheet":"Data","index":2,"n_rows":3,"n_cols":5,"rows_kept":3}
["Main Email","Nombre","Monto","Fecha de corte","Concepto"]
["hello@danielzaldana.com","Daniel Zaldaña",100,"1 de febrero de 2023","Cobro del mes"]
["info@activateportupais.com","Actívate",123.45,"31 de enero de 2023","Cobro semestral"]

{"sheet":"Hoja de control","index":3,"n_rows":27,"n_cols":7,"rows_kept":27,"hidden":true}
[]
[]
[]
[null,"221201-v1.2 -Daniel Zaldaña"]
[null,"INDICACIONES"]
[null,"NO MODIFICAR el encabezado de las hojas OPEN y BaseCorreos."]
[null,"Borrar la información anterior y copiar la información del open de pagos a la hoja OPEN."]
[null,"Dar Clic en el boton VALIDAR BASE, para revisar si se necesita agregar algún correo a la BaseCorreos"]
[null,"Asegurarse en la medida que sea posible de tener la informacíón de la hoja BaseCorreos actualizada."]
[null,"Dar Clic en el boton ENVIAR CORREOS."]
[null,"Leer con cuidado el mensaje de notificación ya que puede alertar por información faltante."]
[null,"Cualquier consulta referente a la macro hacerla llegar a Daniel Zaldaña."]
[null,"MANTENER ABIERTO EL OUTLOOK DE notificacionespago@impressarepuestos.com"]
[]
[null,"DETALLES DE CORREO",{"$nulls":4},"Proximos pasos"]
[null,"Asunto","Notificación de pago"]
[null,"Línea 1","Estimado proveedor: ","Nombre Proveedor"," el día "," por un monto de "]
[null,"Línea 2"," le informa que le hemos efectuado un abono en su cuenta del banco ","BANCO","Fecha","Monto Total"]
[null,"Línea 3","Se adjunta el detalle de las facturas pagadas."]
[null,"Línea 4"]
[null,"Línea 5"]
[null,"Línea 6"]
[null,"Línea 7","Cualquier consulta quedamos al pendiente."]
[null,"Línea 8","Cordialmente."]
[]
[null,"Firma","Edwin Barrera"]
[null,"Firma2","Tesorería Impressa, Tel: 2212-0878 Ext 280"]