{"id":3002,"date":"2021-05-31T07:14:53","date_gmt":"2021-05-31T07:14:53","guid":{"rendered":"https:\/\/sky-it.ro\/clone\/?p=3002"},"modified":"2021-07-23T19:07:18","modified_gmt":"2021-07-23T19:07:18","slug":"cum-se-pot-trimite-email-uri-direct-din-excel","status":"publish","type":"post","link":"https:\/\/sky-it.ro\/clone\/cum-se-pot-trimite-email-uri-direct-din-excel\/","title":{"rendered":"Cum se pot trimite email-uri direct din Excel?"},"content":{"rendered":"<p>[vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; z_index=&#8221;&#8221; padding_top=&#8221;44&#8243; padding_bottom=&#8221;44&#8243;][vc_column width=&#8221;1\/4&#8243;][vc_column_text]<\/p>\n<h3 style=\"text-align: left;\"><strong>Cursuri Office<\/strong><\/h3>\n<h4 style=\"text-align: left;\">Cursuri Excel<\/h4>\n<p style=\"text-align: left;\"><em>Bazandu-ne pe experienta dobandita de-a lungul anilor, am dezvoltat tehnici facile de invatare, cursuri Microsoft adaptate in functie de nivelul fiecarui cursant.<\/em><\/p>\n<p><em>O lista de preturi pentru acestea regasiti <a href=\"https:\/\/sky-it.ro\/clone\/pachete-preturi-cursuri-persoane-fizice-2\/\">aici.<\/a><\/em><\/p>\n<p>[\/vc_column_text][\/vc_column][vc_column width=&#8221;3\/4&#8243;]<div class=\"qode-advanced-tabs qode-advanced-tabs qode-advanced-horizontal-tab clearfix qode-advanced-tab-without-icon qode-advanced-tabs-column-0 clearfix\">\n\t<ul class=\"qode-advanced-tabs-nav\">\n\t\t\t<\/ul>\n\t<div class=\"qode-advanced-tab-container\" id=\"tab-tab-655\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<\/p>\n<h1>Cum se pot trimite email-uri direct din Excel?<\/h1>\n<p>Ai o lista de contacte si adresele de email ale acestora pe care le gestionezi in Excel. Vrei sa trimiti catre aceste contacte, in functie de un criteriu de departajare 2 email-uri personalizate.<\/p>\n<h2>Separarea contactelor in Excel tinand cont de un criteriu de departajare.<\/h2>\n<p>Ca prim pas va, trebui sa separam contactele in functie de criteriul stabilit de catre noi. Ne vom folosi de Excel si vom utiliza <a href=\"https:\/\/youtu.be\/Vreo0hR2YOQ\">functia IF<\/a> pentru a face acest lucru. In functie de criteriul impus o sa generam o coloana noua in care vom returna valorile de adevar sau fals.<\/p>\n<h2>Cum pot seta acest proces, de a trimite email-uri direct din Excel?<\/h2>\n<p>Am sa las mai jos un video in care am detaliat tot acest proces. Este un material gratuit, care sper sa-ti fie util.<br \/>\n<iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/1sT97tWfjQ4\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Accesand link-ul listat mai sus vei ajunge direct pe canalul de Youtube \u2013 (<strong>skyitlearning<\/strong>). In cazul in care iti sunt utile materialele de aici nu uita sa apesi butoanele de Abonare, Like si Share.<\/p>\n<h2>Setarea email-ului direct din Excel<\/h2>\n<p>O sa generam continutul si titlul email-ului folosind functia IF. Functiile de mai jos sunt extrase din materialul video prezentat anterior.<\/p>\n<p><strong>Continut Email<\/strong><\/p>\n<p>=IF(E7=&#8221;&#8221;,&#8221;&#8221;,&#8221;Munca ta a dat rezultate, ai depasit target-ul cu&#8221;&amp;&#8221; &#8222;&amp;E7&amp; &#8221; luna aceasta.&#8221;)<\/p>\n<p><strong>Subiect Email<\/strong><\/p>\n<p>=IF(E4=&#8221;&#8221;,&#8221;&#8221;,&#8221;Felicitari &#8222;&amp;A4 &amp; &#8222;!&#8221;)<\/p>\n<h2>Setarea finala de trimitere email folosind Excel<\/h2>\n<p>Dupa finalizarea setarilor prezentate anterior, va fi necesara configurarea de expediere email. Practic vom plasa hyperlink in spatele unor valori. Simulam existent unor butoane in Excel.<\/p>\n<h2>HYPERLINK Email in Excel<\/h2>\n<p>=IF(E4=&#8221;&#8221;,HYPERLINK(&#8222;mailto:&#8221; &amp; B4 &amp; &#8222;?subject=Poti atinge target-ul!&amp;body=Respecta procedura, cu siguranta vei reusi luna viitoare!&#8221;, &#8222;Trimite Motivatie&#8221;),HYPERLINK(&#8222;mailto:&#8221; &amp; B4 &amp; &#8222;?subject=&#8221;&amp; F4 &amp; &#8222;&amp;body=&#8221; &amp; G4, &#8222;Trimite Email&#8221;))<\/p>\n<p>Daca ai intrebari legate de modul de utilizare al acestei optiuni, ne poti lasa un mesaj in sectiunea de comentarii. \u00a0In cazul in care ai\u00a0 intrebari despre un subiect Excel diferit fata de cel prezent, scrie-ne si iti vom raspunde in cel mult 48 ore!<\/p>\n<p>Speram ca va este util acest tutorial, ne puteti urmari si in zona de social media\/ Facebook\u00a0https:\/\/www.facebook.com\/SkyITLearning\/<\/p>\n<p>De asemenea putem sa va ajutam si cu programe de training personalizate, adaptate nevoilor Dvs. Cursurile sunt destinate atat persoanelor fizice cat si pentru companii, nu ezitati sa ne <a href=\"https:\/\/sky-it.ro\/clone\/pachete-preturi-cursuri-persoane-fizice-2\/\">contactati<\/a> pentru mai multe detalii.<\/p>\n<p>Nu uita\u2026<\/p>\n<p>Invata astazi pentru maine![\/vc_column_text]<\/div><\/div>[\/vc_column][\/vc_row][vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; css=&#8221;.vc_custom_1473086245677{padding-top: 13px !important;padding-bottom: 13px !<\/p>\n<p>important;background-color: #ffffff !important;}&#8221;][vc_column]<div class='qode_carousels_holder clearfix'><div class='qode_carousels' data-number-of-visible-items='4'><ul class='slides'><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel1-1.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel-1.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel3.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel2-1.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel5.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel4.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel7.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel6.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel9.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel8.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel11.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel10.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel13.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel12.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel15.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel14.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><\/ul><\/div><\/div>[\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; z_index=&#8221;&#8221; padding_top=&#8221;44&#8243; padding_bottom=&#8221;44&#8243;][vc_column width=&#8221;1\/4&#8243;][vc_column_text] Cursuri Office Cursuri Excel Bazandu-ne pe experienta dobandita de-a lungul anilor, am dezvoltat tehnici facile de invatare, cursuri Microsoft adaptate in functie de nivelul fiecarui cursant. O lista de preturi pentru acestea regasiti&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/3002"}],"collection":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/comments?post=3002"}],"version-history":[{"count":8,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/3002\/revisions"}],"predecessor-version":[{"id":3026,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/3002\/revisions\/3026"}],"wp:attachment":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/media?parent=3002"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/categories?post=3002"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/tags?post=3002"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/yst_prominent_words?post=3002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}