Last active
March 10, 2019 12:14
-
-
Save ezhov-da/a9d1d4eddeb8a7cc6258280dc23c61aa to your computer and use it in GitHub Desktop.
vba отправка почты
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'ОТПРАВЛЯЕМ ПОЧТУ<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< | |
If (textForSend <> "") Then | |
Dim o_Mess, v_Conf | |
v_Conf = "http://schemas.microsoft.com/cdo/configuration/" | |
Set o_Mess = CreateObject("CDO.Message") | |
With o_Mess | |
.To = "111@вы.ru" 'куда отправляем | |
.From = "111@ывыв.ru" 'имя отправителя + Email | |
.SUBJECT = SUBJECT 'Тема письма | |
.TextBody = textForSend 'Сообщение | |
.TextBodyPart.Charset = "windows-1251" 'русская кодировка | |
With .Configuration.Fields | |
.Item(v_Conf & "sendusing") = 2 'без использования каталога Server Exchange | |
.Item(v_Conf & "smtpserver") = "---" 'Адрес SMTP-сервера | |
.Item(v_Conf & "smtpauthenticate") = 1 'Тип авторизации | |
.Item(v_Conf & "sendusername") = LOGIN 'здесь имя пользователя без @ | |
.Item(v_Conf & "sendpassword") = PASS 'пароль | |
.Item(v_Conf & "smtpserverport") = 25 'порт (альтернативный - 465) | |
.Item(v_Conf & "smtpusessl") = False 'использовать ли шифрованое подключение SSL | |
.Item(v_Conf & "smtpconnectiontimeout") = 60 'Время до завершения повторных попыток подключения | |
.Update | |
End With | |
.send | |
End With | |
Set o_Mess = Nothing | |
End If |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment