Tema: Re: Send mail from VBA
Autorius: toms
Data: 2016-03-04 11:41:39
Nepamenu detaliu, senai dariau.
Siaip persiunciu exceli su sia funkcija i kita PC nieko papildomai nesukisu 
ir be jokiu papildomu nustatymu veikia. Nebutinas suinstalinatas Outlookas 
ar kas nors kitas. Kasdien naudojasi ~30 zmoniu su skirtingom win,office 
versijom.

o sita funkcija naudojau kai reikejo siust per outlooka

Sub OutlookSend(subject_, body_, To_, From_, Optional Attachment_ = "", 
Optional CC_ = "", Optional BCC_ = "")
Dim OutApp, OutMail
    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)

    On Error Resume Next
    With OutMail

        .to = To_
        .CC = CC_
        .BCC = BCC_
        .Subject = subject_
        .body = body_
        .Attachments.Add Attachment_
        .Display   ' arba naudoji .Send kad iskart siustu.
    End With
    On Error GoTo 0

    Set OutMail = Nothing
    Set OutApp = Nothing
End Sub