How to insert signature in VBScript for sending emails from QlikView

Anonymous — Mon, 30 Mar 2015 10:24:46 GMT

Hi All,

I desperately in need of your help for inserting my outlook's default signature in the below VBScript for sending emails from QlikView

FUNCTION GlobalFEPSendReport()

Dim objEmail

Const cdoSendUsingPort = 2

Const cdoAnonymous = 0

Const cdoBasic = 1

Const cdoNTLM = 2

SMTPServer = "xxxxx.bbb.com"

Const SMTPPort = 25

Const SMTPTimeout = 60

'Sending mail

Set objEmail = CreateObject("CDO.Message")

Set objConf = objEmail.Configuration

Set objFlds = objConf.Fields

With objFlds

'---------------------------------------------------------------------

' SMTP server details

.Update

'---------------------------------------------------------------------

msgbox "Mail Sent Successfully"

End With

objEmail.To = "" 'Email Recipient

objEmail.cc = "" 'Email Recipient

objEmail.From = "" 'Email Sender

objEmail.Subject = "Report on Global FEP Alerts" & ":" & " " & PreviousWeekNum() ' Subject

objEmail.HTMLBody = "Please find attached the report on Global FEP alerts for the" & " " & PreviousWeekNum() &_

"<BR><BR>Thank You<BR>"

objEmail.AddAttachment "" ' Attachement

objEmail.Send

Set objFlds = Nothing

Set objConf = Nothing

Set objEmail = Nothing

END FUNCTION

topic How to insert signature in VBScript for sending emails from QlikView in QlikView