{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Список","акт1"],"not_rendered":{"charts":0,"images":1,"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":"Список","index":0,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["№","Краткое наименование","Полное наименование","тел./факс","email","email2","icq","Фактический адрес","ПРИМЕЧ1","Примечание","примечание 2"]
[1,"Александр Борисов","г.Чебоксары, пр.И.Яковлева, д.1",89176541223,null,"asemenov@cheb.ab.com"]
[2,"Иванов Петр","г.Чебоксары, Московский проспект, д.40","факс 221426",null,"kaza@ela.ru"]
[3,"Федотов Артем","Хозяйственный проезд, д.7а",835565,null,"07vga@mail.ru"]
[4,"АИР","ул. Рудницкого, 31",53316,null,"ai_k@mail.ru"]
[5,"Савеев Павел","пл.Октяборьской революции,д.23","23-00-77",null,"elpri-hta@mail.ru"]
[6,"Исаеев Олег","ул.Водопроводная, д.22",null,null,"ai_k@yandex.ru"]
[7,"Саврев Павел","пл.Октяборьской революции,д.43","23-00-77",null,"pri-hta@mail.ru"]

{"sheet":"акт1","index":1,"n_rows":28,"n_cols":24,"rows_kept":28,"cut":false,"hidden":false,"merged":[[63,0,63,20],[66,2,66,5],[66,20,66,21],[7,0,8,19],[0,0,0,18],[51,1,51,5],[51,6,51,18],[58,0,58,5],[59,0,59,22],[60,0,60,15],[61,0,61,19],[48,1,48,5],[48,6,48,18],[49,1,49,5],[49,6,49,18],[50,1,50,5],[50,6,50,18],[45,1,45,5],[45,6,45,18],[46,1,46,5],[46,6,46,18],[47,1,47,5],[47,6,47,18],[42,1,42,5],[42,6,42,18],[43,1,43,5],[43,6,43,18],[44,1,44,5],[44,6,44,18],[34,0,34,4],[34,5,34,6],[38,8,38,9],[40,0,40,1],[40,2,40,22],[41,1,41,18],[24,1,24,5],[24,6,24,18],[31,0,31,2],[31,4,31,5],[33,0,33,4],[33,5,33,6],[21,1,21,5],[21,6,21,18],[22,1,22,5],[22,6,22,18],[23,1,23,5],[23,6,23,18],[18,1,18,5],[18,6,18,18],[19,1,19,5],[19,6,19,18],[20,1,20,5],[20,6,20,18],[15,1,15,5],[15,6,15,18],[16,1,16,5],[16,6,16,18],[17,1,17,5],[17,6,17,18],[11,7,11,9],[11,10,11,13],[11,16,11,22],[13,0,13,1],[13,2,13,22],[14,1,14,18],[9,13,9,14],[9,15,9,22]]}
["Основная задача отправить сформированный файл (по средствам макроса на кнопке \"Отправить\")\n на указанный емайл в ячейке U5"]
["ячейка u5 меняется с названием в выпадающем списке"]
["(по нажатии кнопки \"отправить\" формируется на диске D:\\акт1.pdf)"]
["не получилось чтобы название файла было как указано в выпадающем списке так же, если есть решение прошу помочь реализовать"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Список!B:K,MATCH(C14,Список!C:C,0),5)","v":"ai_k@mail.ru"}]
["*Вопрос как адрес емайл из ячейки U5 преобразовать в емайл ссылку"]
[]
["Было бы замечательно если при нажатии на кнопку отправить формировалось письмо в The Bat именно на адрес который появляется в ячейке u5"]
[]
[]
[]
[null,null,null,null,null,null,null,"АКТ №",null,null,1]
[]
["Адрес:",null,"ул. Рудницкого, 31"]
["№","Товар",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ед.изм.","Кол.","Цена","Сумма"]
[1,"Книга 1",null,null,null,null,"Пространство и время",null,null,null,null,null,null,null,null,null,null,null,null,"шт",1,1000,1000,{"$f":"IFERROR(W16,0)","v":1000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W18","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(W24,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(W25,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Итого:",{"$f":"SUM(X16:X25)","v":1000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]