- Популярные видео
- Авто
- Видео-блоги
- ДТП, аварии
- Для маленьких
- Еда, напитки
- Животные
- Закон и право
- Знаменитости
- Игры
- Искусство
- Комедии
- Красота, мода
- Кулинария, рецепты
- Люди
- Мото
- Музыка
- Мультфильмы
- Наука, технологии
- Новости
- Образование
- Политика
- Праздники
- Приколы
- Природа
- Происшествия
- Путешествия
- Развлечения
- Ржач
- Семья
- Сериалы
- Спорт
- Стиль жизни
- ТВ передачи
- Танцы
- Технологии
- Товары
- Ужасы
- Фильмы
- Шоу-бизнес
- Юмор
Send email to groups, with an attachment from Excel
Send an email to groups, with an attachment from Excel
Use group names created in outlook to send emails with attachments.Send an email to each member of a group with an attachment from a list in Excel
code
Note I am not able to show you the not equal to a symbol in my description
Sub Send_email_fromexcel()
Dim edress As String
Dim subj As String
Dim message As String
Dim filename As String
Dim outlookapp As Object
Dim outlookmailitem As Object
Dim myAttachments As Object
Dim path As String
Dim lastrow As Integer
Dim attachment As String
Dim x As Integer
x = 2
Do While Sheet1.Cells(x, 1) (not equal to symbol) ""
Set outlookapp = CreateObject("Outlook.Application")
Set outlookmailitem = outlookapp.createitem(0)
Set myAttachments = outlookmailitem.Attachments
path = "C:\Users\Barb\Documents\statements\"
edress = Sheet1.Cells(x, 1)
subj = Sheet1.Cells(x, 2)
filename = Sheet1.Cells(x, 3)
attachment = path + filename
outlookmailitem.To = edress
outlookmailitem.cc = ""
outlookmailitem.bcc = ""
outlookmailitem.Subject = subj
outlookmailitem.body = "Please find your statement attached" & vbCrLf & "Best Regards"
myAttachments.Add (attachment)
outlookmailitem.display
outlookmailitem.send
lastrow = lastrow + 1
edress = ""
x = x + 1
Loop
Set outlookapp = Nothing
Set outlookmailitem = Nothing
End Sub
For more help visit my website http://www.easyexcelanswers.com or email me at easyexcelanswers@gmail.com.
I can customize this Excel application for your exact needs for a fixed price of $50. The work is normally returned within 24hrs.
I am able to provide online help on your computer at a reasonable rate.
MY videos are all created on Camtasia.
http://send.onenetworkdirect.net/z/582993/CD237560/
Follow me on Facebook
https://www.facebook.com/easyexcel.answers
Видео Send email to groups, with an attachment from Excel канала Barb Henderson
Use group names created in outlook to send emails with attachments.Send an email to each member of a group with an attachment from a list in Excel
code
Note I am not able to show you the not equal to a symbol in my description
Sub Send_email_fromexcel()
Dim edress As String
Dim subj As String
Dim message As String
Dim filename As String
Dim outlookapp As Object
Dim outlookmailitem As Object
Dim myAttachments As Object
Dim path As String
Dim lastrow As Integer
Dim attachment As String
Dim x As Integer
x = 2
Do While Sheet1.Cells(x, 1) (not equal to symbol) ""
Set outlookapp = CreateObject("Outlook.Application")
Set outlookmailitem = outlookapp.createitem(0)
Set myAttachments = outlookmailitem.Attachments
path = "C:\Users\Barb\Documents\statements\"
edress = Sheet1.Cells(x, 1)
subj = Sheet1.Cells(x, 2)
filename = Sheet1.Cells(x, 3)
attachment = path + filename
outlookmailitem.To = edress
outlookmailitem.cc = ""
outlookmailitem.bcc = ""
outlookmailitem.Subject = subj
outlookmailitem.body = "Please find your statement attached" & vbCrLf & "Best Regards"
myAttachments.Add (attachment)
outlookmailitem.display
outlookmailitem.send
lastrow = lastrow + 1
edress = ""
x = x + 1
Loop
Set outlookapp = Nothing
Set outlookmailitem = Nothing
End Sub
For more help visit my website http://www.easyexcelanswers.com or email me at easyexcelanswers@gmail.com.
I can customize this Excel application for your exact needs for a fixed price of $50. The work is normally returned within 24hrs.
I am able to provide online help on your computer at a reasonable rate.
MY videos are all created on Camtasia.
http://send.onenetworkdirect.net/z/582993/CD237560/
Follow me on Facebook
https://www.facebook.com/easyexcel.answers
Видео Send email to groups, with an attachment from Excel канала Barb Henderson
Send email to groups with an attachment from Excel microsoft excel visual basic for applications excel vba send email from excel email from excel microsoft excel (software) excel tutorial send email from excel list with attachment send email from excel using vba send email from excel macro send email from excel based on cell value
Комментарии отсутствуют
Информация о видео
11 апреля 2018 г. 19:50:16
00:02:07
Другие видео канала





















