{"id":78,"date":"2011-11-02T01:44:28","date_gmt":"2011-11-01T23:44:28","guid":{"rendered":"http:\/\/excelvbatips.co.il\/?page_id=78"},"modified":"2018-06-13T07:34:09","modified_gmt":"2018-06-13T04:34:09","slug":"%d7%a9%d7%9c%d7%99%d7%97%d7%aa-%d7%a7%d7%95%d7%91%d7%a5-%d7%90%d7%a7%d7%a1%d7%9c-%d7%91%d7%90%d7%99-%d7%9e%d7%99%d7%99%d7%9c-%d7%91%d7%90%d7%9e%d7%a6%d7%a2%d7%95%d7%aa-%d7%90%d7%a7%d7%a1%d7%9c-vba","status":"publish","type":"page","link":"https:\/\/excelvbatips.co.il\/?page_id=78","title":{"rendered":"\u05e9\u05dc\u05d9\u05d7\u05ea \u05e7\u05d5\u05d1\u05e5 \u05d0\u05e7\u05e1\u05dc \u05d1\u05de\u05d9\u05d9\u05dc \u05d1 VBA"},"content":{"rendered":"

\u05e9\u05dc\u05d9\u05d7\u05ea \u05e7\u05d5\u05d1\u05e5 \u05d0\u05e7\u05e1\u05dc \u05d1\u05d0\u05d9 \u05de\u05d9\u05d9\u05dc \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea \u05d0\u05e7\u05e1\u05dc VBA<\/h1>\n

\u05e4\u05e2\u05de\u05d9\u05dd \u05e8\u05d1\u05d5\u05ea \u05e8\u05d5\u05e6\u05d9\u05dd \u05dc\u05e9\u05dc\u05d5\u05d7 \u05e7\u05d5\u05d1\u05e5 \u05d1\u05d0\u05d9 \u05de\u05d9\u05d9\u05dc.<\/p>\n

\u05e7\u05d5\u05d3 \u05e7\u05e6\u05e8 \u05d6\u05d4 \u05d9\u05e2\u05e9\u05d4 \u05d0\u05ea \u05d4\u05e2\u05d1\u05d5\u05d3\u05d4 \u05e2\u05d1\u05d5\u05e8\u05db\u05dd.<\/p>\n

\u05d1\u05d3\u05d5\u05d2\u05de\u05d0 \u05d6\u05d5 \u05d4\u05e7\u05d5\u05d1\u05e5 \u05d4\u05e4\u05e2\u05d9\u05dc \u05d1\u05d0\u05e7\u05e1\u05dc \u05e0\u05e9\u05dc\u05d7, \u05d0\u05d1\u05dc \u05d0\u05ea\u05dd \u05d9\u05db\u05d5\u05dc\u05d9\u05dd \u05dc\u05e9\u05dc\u05d5\u05d7 \u05db\u05dc \u05e7\u05d5\u05d1\u05e5.<\/p>\n

Sub sendActiveWorkbook()<\/p>\n

\n

'\u05de\u05e9\u05dc\u05d5\u05d7 \u05d4\u05e7\u05d5\u05d1\u05e5 \u05d4\u05e4\u05e2\u05d9\u05dc \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea OUTLOOK<\/p>\n<\/blockquote>\n

\n

ActiveWorkbook.SendMail "michal@eso.co.il", " \u05e9\u05dc\u05d9\u05d7\u05ea \u05d4\u05e7\u05d5\u05d1\u05e5 \u05d4\u05e4\u05e2\u05d9\u05dc \u05d1\u05d0\u05e7\u05e1\u05dc \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea VBA"<\/p>\n<\/blockquote>\n

End Sub<\/p>\n

\u05de\u05d1\u05e0\u05d4 \u05d4\u05e7\u05d5\u05d3 \u05dc\u05de\u05e9\u05dc\u05d5\u05d7 \u05dc\u05de\u05e1\u05e4\u05e8 \u05e0\u05de\u05e2\u05e0\u05d9\u05dd:<\/strong><\/div>\n
\u200bSub sendActiveWorkbook()<\/div>\n
<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0ActiveWorkbook.SendMail Array("michal@eso.co.il", "michal@eso.co.il"), "\u05e9\u05dc\u05d9\u05d7\u05ea \u05d4\u05e7\u05d5\u05d1\u05e5 \u05d4\u05e4\u05e2\u05d9\u05dc \u05d1\u05d0\u05e7\u05e1\u05dc \u05dc\u05de\u05e1\u05e4\u05e8 \u05e0\u05de\u05e2\u05e0\u05d9\u05dd \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea VBA"<\/div>\n
<\/div>\n
End Sub\u200b<\/div>\n

\u05dc- SendMail \u05d9\u05e9 3 \u05d0\u05e8\u05d2\u05d5\u05de\u05e0\u05d8\u05d9\u05dd<\/strong>:<\/p>\n

1. \u05dc\u05de\u05d9 \u05e9\u05d5\u05dc\u05d7\u05d9\u05dd \u05d0\u05ea \u05d4\u05de\u05d9\u05d9\u05dc – \u05d7\u05d5\u05d1\u05d4!<\/strong> \u05db\u05ea\u05d5\u05d1\u05ea \u05de\u05d9\u05d9\u05dc \u05ea\u05e7\u05e0\u05d9\u05ea \u05d1\u05ea\u05d5\u05da \u05d2\u05e8\u05e9\u05d9\u05d9\u05dd , \u05e0\u05d9\u05ea\u05df \u05dc\u05de\u05e1\u05e4\u05e8 \u05db\u05ea\u05d5\u05d1\u05d5\u05ea \u05de\u05d5\u05e4\u05e8\u05d3\u05d5\u05ea \u05d1\u05e4\u05e1\u05d9\u05e7.<\/p>\n

2. \u05e0\u05d5\u05e9\u05d0 \u2013 subject<\/strong> : \u05d1\u05ea\u05d5\u05da \u05d2\u05e8\u05e9\u05d9\u05d9\u05dd.<\/p>\n

3. \u05dc\u05de\u05d9 \u05dc\u05d4\u05d7\u05d6\u05d9\u05e8 \u05d0\u05ea \u05d4\u05de\u05d9\u05d9\u05dc <\/strong>\u05dc\u05e9\u05d9\u05de\u05d5\u05e9 \u05e8\u05e7 \u05d0\u05dd \u05e8\u05d5\u05e6\u05d9\u05dd \u05e9\u05de\u05d9\u05d9\u05dc \u05d7\u05d5\u05d6\u05e8 \u05d9\u05d4\u05d9\u05d4 \u05dc\u05d0\u05d9 \u05de\u05d9\u05d9\u05dc \u05d0\u05d7\u05e8 \u05d5\u05dc\u05d0 \u05dc\u05db\u05ea\u05d5\u05d1\u05ea \u05d4\u05e9\u05d5\u05dc\u05d7.<\/p>\n

 <\/p>\n

\u05d1 \u05d4 \u05e6 \u05dc \u05d7 \u05d4!<\/h1>\n","protected":false},"excerpt":{"rendered":"

\u05e9\u05dc\u05d9\u05d7\u05ea \u05e7\u05d5\u05d1\u05e5 \u05d0\u05e7\u05e1\u05dc \u05d1\u05d0\u05d9 \u05de\u05d9\u05d9\u05dc \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea \u05d0\u05e7\u05e1\u05dc VBA \u05e4\u05e2\u05de\u05d9\u05dd \u05e8\u05d1\u05d5\u05ea \u05e8\u05d5\u05e6\u05d9\u05dd \u05dc\u05e9\u05dc\u05d5\u05d7 \u05e7\u05d5\u05d1\u05e5 \u05d1\u05d0\u05d9 \u05de\u05d9\u05d9\u05dc. \u05e7\u05d5\u05d3 \u05e7\u05e6\u05e8 \u05d6\u05d4 \u05d9\u05e2\u05e9\u05d4 \u05d0\u05ea \u05d4\u05e2\u05d1\u05d5\u05d3\u05d4 \u05e2\u05d1\u05d5\u05e8\u05db\u05dd. \u05d1\u05d3\u05d5\u05d2\u05de\u05d0 \u05d6\u05d5 \u05d4\u05e7\u05d5\u05d1\u05e5 \u05d4\u05e4\u05e2\u05d9\u05dc \u05d1\u05d0\u05e7\u05e1\u05dc \u05e0\u05e9\u05dc\u05d7, \u05d0\u05d1\u05dc \u05d0\u05ea\u05dd \u05d9\u05db\u05d5\u05dc\u05d9\u05dd \u05dc\u05e9\u05dc\u05d5\u05d7 \u05db\u05dc \u05e7\u05d5\u05d1\u05e5. Sub sendActiveWorkbook() '\u05de\u05e9\u05dc\u05d5\u05d7 \u05d4\u05e7\u05d5\u05d1\u05e5 \u05d4\u05e4\u05e2\u05d9\u05dc \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea …<\/span> \u05d4\u05de\u05e9\u05da \u05e7\u05e8\u05d9\u05d0\u05d4 ←<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/pages\/78"}],"collection":[{"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=78"}],"version-history":[{"count":5,"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/pages\/78\/revisions"}],"predecessor-version":[{"id":261,"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/pages\/78\/revisions\/261"}],"wp:attachment":[{"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}