{"id":9768,"date":"2022-12-26T15:43:19","date_gmt":"2022-12-26T18:43:19","guid":{"rendered":"https:\/\/ajuda.locaweb.com.br\/?post_type=ht_kb&#038;p=9768"},"modified":"2023-01-26T15:56:10","modified_gmt":"2023-01-26T18:56:10","slug":"como-fazer-o-envio-via-smtpmail-hospedagem-de-sites","status":"publish","type":"ht_kb","link":"https:\/\/www.locaweb.com.br\/ajuda\/wiki\/como-fazer-o-envio-via-smtpmail-hospedagem-de-sites\/","title":{"rendered":"Como fazer o envio via SMTPMail &#8211; Hospedagem de Sites"},"content":{"rendered":"<p><span id=\"Como_enviar_e-mails_com_o_componente_SMTPMail.3F\" class=\"mw-headline\">    \t\t<div class=\"hts-messages hts-messages--info  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\"><b>Informa\u00e7\u00e3o!<\/b><\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tO<b> SMTPMail<\/b>\u00a0oferece um desempenho no servidor significativamente melhor do que outros componentes populares e suporta envio em massa de e-mails atrav\u00e9s do m\u00e9todo MassMail.    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t <\/span><\/p>\n<h6>Veja os c\u00f3digos<\/h6>\n<ul>\n<li>Utilize o exemplo abaixo como refer\u00eancia para uso do <strong>SMTPMail<\/strong> com o m\u00e9todo <strong>MassMail<\/strong> (o par\u00e2metro\u00a0<b>RemoteHost<\/b>\u00a0n\u00e3o deve ser alterado):<\/li>\n<\/ul>\n<pre class=\"de1\"><span class=\"sy1\">&lt;%<\/span> \r\n<span class=\"kw1\" style=\"color: #800080;\">Set <\/span>mailer <span class=\"sy0\" style=\"color: #008000;\">= <\/span><span class=\"kw1\" style=\"color: #800080;\">Server<\/span>.<span class=\"kw3\" style=\"color: #333399;\">CreateObject<\/span><span class=\"br0\" style=\"color: #008000;\">(<\/span><span class=\"st0\" style=\"color: #ff0000;\">\"SoftArtisans.SMTPMail\"<\/span><span class=\"br0\" style=\"color: #008000;\">)<\/span> \r\n\u00a0\r\nREM neste ponto, definimos o <span class=\"kw3\">CharSet<\/span> utilizado para realizar o envio <span class=\"kw1\" style=\"color: #800080;\">do <\/span>e-mail, \r\nREM evitando assim problemas com acentua\u00e7\u00e3o no recebimento <span class=\"kw1\" style=\"color: #800080;\">do <\/span>e-mail enviado\r\nREM <span class=\"nu0\" style=\"color: #993366;\">1<\/span> <span class=\"sy0\" style=\"color: #008000;\">= <\/span>US ASCII , <span class=\"nu0\" style=\"color: #993366;\">2<\/span> <span class=\"sy0\" style=\"color: #008000;\">= <\/span>ISO-<span style=\"color: #993366;\"><span class=\"nu0\">9959<\/span>-<span class=\"nu0\">1<\/span><\/span>\r\nmailer.<span class=\"kw3\" style=\"color: #333399;\">charset <\/span><span class=\"sy0\" style=\"color: #008000;\">= <\/span><span class=\"nu0\" style=\"color: #993366;\">2<\/span>\r\n\u00a0\r\nmailer.<span class=\"me1\" style=\"color: #993300;\">Subject <\/span><span class=\"sy0\" style=\"color: #008000;\">= <\/span><span class=\"st0\" style=\"color: #ff0000;\">\"T\u00edtulo da mensagem\u00a0%%numero%%\"<\/span> \r\nmailer.<span class=\"me1\" style=\"color: #993300;\">BodyText <\/span><span class=\"sy0\" style=\"color: #008000;\">= <\/span><span style=\"color: #ff0000;\"><span class=\"st0\">\"Prezado\u00a0%%coluna2%%:\"<\/span> <span class=\"sy0\" style=\"color: #008000;\">&amp; <\/span>vcCrLf<\/span> \r\n\u00a0\r\nmailer.<span class=\"me1\" style=\"color: #993300;\">FromName <\/span><span class=\"sy0\" style=\"color: #008000;\">= <\/span><span class=\"st0\" style=\"color: #ff0000;\">\"Nome do remetente\" <\/span>\r\n\u00a0\r\nREM Na coluna1 por exemplo o n\u00famero <span class=\"kw1\" style=\"color: #800080;\">do <\/span>pedido, na coluna2 o nome da pessoa \r\nREM Na coluna3 necessariamente deve ser o e-mail <span class=\"br0\" style=\"color: #008000;\">(<\/span>destinat\u00e1rio<span class=\"br0\" style=\"color: #008000;\">) <\/span>\r\nREM Use os delimitadores<span class=\"sy0\" style=\"color: #008000;\"> %%<\/span> de cada lado dos nomes das colunas para indicar ao m\u00e9todo MassMail quais colunas ele deve puxar \r\nMailer.<span class=\"me1\" style=\"color: #993300;\">AddRecipient <\/span><span style=\"color: #ff0000;\"><span class=\"st0\">\"%%coluna1%%\u00a0%%coluna2%%\"<\/span>, <span class=\"st0\">\"%%coluna3%%\"<\/span> <\/span>\r\n\u00a0\r\nREM Servidor de SMTP \r\nmailer.<span class=\"me1\" style=\"color: #993300;\">RemoteHost<\/span> <span class=\"sy0\">=<\/span> <span class=\"st0\" style=\"color: #ff0000;\">\"localhost\"<\/span> \r\n\u00a0\r\nREM Conex\u00e3o com o banco de dados \r\nstrConnect <span class=\"sy0\" style=\"color: #008000;\">= <\/span><span class=\"st0\" style=\"color: #ff0000;\">\"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\\home\\LOGIN\\dados\\massmail.mdb;\"<\/span>\r\n\u00a0\r\n<span class=\"kw1\" style=\"color: #800080;\">Dim <\/span>objRec \r\n<span class=\"kw1\" style=\"color: #800080;\">Dim <\/span>objCommand \r\n\u00a0\r\n<span class=\"kw1\" style=\"color: #800080;\">Set <\/span>objCommand <span class=\"sy0\" style=\"color: #008000;\">= <\/span><span class=\"kw1\" style=\"color: #800080;\">Server<\/span>.<span class=\"kw3\" style=\"color: #333399;\">CreateObject<\/span><span class=\"br0\" style=\"color: #008000;\">(<\/span><span class=\"st0\" style=\"color: #ff0000;\">\"ADODB.Command\"<\/span><span class=\"br0\" style=\"color: #008000;\">) <\/span>\r\n<span class=\"kw1\" style=\"color: #800080;\">Set <\/span>objRec <span class=\"sy0\" style=\"color: #008000;\">= <\/span><span class=\"kw1\" style=\"color: #800080;\">Server<\/span>.<span class=\"kw3\" style=\"color: #333399;\">CreateObject<\/span><span class=\"br0\" style=\"color: #008000;\">(<\/span><span class=\"st0\" style=\"color: #ff0000;\">\"ADODB.RecordSet\"<\/span><span class=\"br0\" style=\"color: #008000;\">) <\/span>\r\n\u00a0\r\nObjCommand.<span class=\"me1\" style=\"color: #993300;\">ActiveConnection <\/span><span class=\"sy0\" style=\"color: #008000;\">= <\/span>strConnect \r\nObjCommand.<span class=\"me1\" style=\"color: #993300;\">CommandText <\/span><span class=\"sy0\" style=\"color: #008000;\">= <\/span><span class=\"st0\" style=\"color: #ff0000;\">\"SELECT coluna2, coluna3, coluna1, numero FROM nome_tabela\"<\/span> \r\n<span class=\"kw1\" style=\"color: #800080;\">Set <\/span>objRec <span class=\"sy0\" style=\"color: #008000;\">= <\/span>objCommand.<span class=\"kw3\" style=\"color: #333399;\">Execute <\/span>\r\n\u00a0\r\nREM Enquanto n\u00e3o chegar no \u00faltimo registro <span class=\"kw1\" style=\"color: #800080;\">do <\/span>banco, manda e-mail \r\n<span class=\"kw1\" style=\"color: #800080;\">If <\/span>mailer.<span class=\"me1\" style=\"color: #993300;\">MassMail <\/span><span class=\"br0\" style=\"color: #008000;\">(<\/span>objRec<span class=\"br0\" style=\"color: #008000;\">) <\/span><span class=\"kw1\" style=\"color: #800080;\">Then \r\nResponse<\/span>.<span class=\"kw3\" style=\"color: #333399;\">Write <\/span><span class=\"st0\" style=\"color: #ff0000;\">\"Enviando e-mail...\" <\/span>\r\n<span class=\"kw1\" style=\"color: #800080;\">Else \r\nResponse<\/span>.<span class=\"kw3\" style=\"color: #333399;\">Write<\/span><span class=\"st0\" style=\"color: #ff0000;\"> \"Falhou o envio.\" <\/span>\r\n<span style=\"color: #800080;\"><span class=\"kw1\">End<\/span> <span class=\"kw1\">If<\/span> <\/span>\r\n\u00a0\r\n<span class=\"kw1\" style=\"color: #800080;\">Set <\/span>objRec <span class=\"sy0\" style=\"color: #008000;\">= <\/span><span class=\"kw2\" style=\"color: #0000ff;\">nothing <\/span>\r\n<span class=\"kw1\" style=\"color: #800080;\">Set <\/span>mailer <span class=\"sy0\" style=\"color: #008000;\">=<\/span><span class=\"kw2\" style=\"color: #0000ff;\"> nothing <\/span>\r\n\u00a0\r\n<span class=\"sy1\">%&gt;<\/span><\/pre>\n<div class=\"alert alert-info\"><\/div>\n<ul>\n<li>Lembrando que sua hospedagem poder\u00e1 ter um dos dois caminhos abaixo:<\/li>\n<\/ul>\n<pre>e:\\home\\LOGIN\\web\u00a0ou\u00a0s:\\home\\LOGIN\\web<\/pre>\n<ul>\n<li>Deve ser criado um <a href=\"https:\/\/ajuda.locaweb.com.br\/wiki\/como-instalar-um-banco-de-dados-hospedagem-de-sites\/\" target=\"_blank\" rel=\"noopener noreferrer\">banco de dados<\/a> com o nome de\u00a0<b>massmail.mdb<\/b>.<\/li>\n<\/ul>\n<p>Neste arquivo, deve existir uma tabela com o nome nome_tabela com as seguintes colunas:<\/p>\n<ul>\n<li>Numero (ser\u00e1 usado como n\u00famero de controle ou n\u00famero de pedido, se for com\u00e9rcio);<\/li>\n<li>Coluna2 (Primeiro nome do cliente &#8211; de quem receber\u00e1 o e-mail);<\/li>\n<li>Coluna1 (\u00daltimo nome do cliente);<\/li>\n<li>Coluna3 (endere\u00e7o de e-mail de quem receber\u00e1 o e-mail).<\/li>\n<\/ul>\n    \t\t<div class=\"hts-messages hts-messages--info  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\"><b>Conhe\u00e7a!<\/b><\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tAgora que voc\u00ea conheceu o SMTPMail e utilizou em sua aplica\u00e7\u00e3o, confira nosso servi\u00e7o de <a href=\"https:\/\/www.locaweb.com.br\/vps-locaweb\" target=\"_blank\" rel=\"noopener noreferrer\">VPS Locaweb<\/a>!    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n","protected":false},"excerpt":{"rendered":"<p>Veja os c\u00f3digos Utilize o exemplo abaixo como refer\u00eancia para uso do SMTPMail com o m\u00e9todo MassMail (o par\u00e2metro\u00a0RemoteHost\u00a0n\u00e3o deve ser alterado): &lt;% Set mailer = Server.CreateObject(&#8220;SoftArtisans.SMTPMail&#8221;) \u00a0 REM neste ponto, definimos o CharSet utilizado para realizar o envio do e-mail, REM evitando assim problemas com acentua\u00e7\u00e3o no recebimento do&#8230;<\/p>\n","protected":false},"author":6,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[119],"ht-kb-tag":[418],"class_list":["post-9768","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-hospedagem-de-sites","ht_kb_tag-categoriahospedagem"],"_links":{"self":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/9768","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/comments?post=9768"}],"version-history":[{"count":9,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/9768\/revisions"}],"predecessor-version":[{"id":29613,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/9768\/revisions\/29613"}],"wp:attachment":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/media?parent=9768"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb-category?post=9768"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb-tag?post=9768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}