topic Re: sending mail using VB Script(Macros) in QlikView

sending mail using VB Script(Macros)

Wed, 25 Jun 2014 06:58:41 GMT

HI guyz,

can any give me snippet to send mail with system pics in the body of the mail(not as attachment) and i am working on remote desktop.

Thanks in Advace

Regards

Sampath Botla.

Re: sending mail using VB Script(Macros)

vikasmahajan — Wed, 25 Jun 2014 09:04:04 GMT

pfa sample

Vikas

Re: sending mail using VB Script(Macros)

Anonymous — Wed, 25 Jun 2014 09:07:39 GMT

Hi try the following

sub SELECT_OT

SendToCC = ActiveDocument.GetSheetObject("TX101").gettext
'ActiveDocument.GetSheetObject("TX99").copytexttoclipboard
hi = ActiveDocument.GetSheetObject("TX98").gettext
go = ActiveDocument.GetSheetObject("TX111").GetText
'Sbjct = ActiveDocument.GetSheetObject("TX113").GetText
Set myApp = CreateObject ("Outlook.Application")
Set myMessage = myApp.CreateItem(olMailItem)
myMessage.BodyFormat = 3 'Outlook.OlBodyFormat.olFormatRichText

myMessage.To = "receipient@emailid"
myMessage.Subject = ActiveDocument.GetSheetObject("TX113").GetText
myMessage.cc = SendToCC
myMessage.Body = go
myMessage.Display

'myMessage.Send
'msgbox("Mail Sent")
Set myMessage = Nothing
Set myApp = Nothing
Set myInspector = Nothing
Set myDoc = Nothing

ActiveDocument.Fields("Code C@pplis").Clear
ActiveDocument.Fields("Template").Clear
ActiveDocument.Fields("Techno").Clear
End sub

................

It is working for my app

Thanks

Bhumika

Re: sending mail using VB Script(Macros)

Wed, 25 Jun 2014 09:20:48 GMT

Hi Bhumika,

i am working on remote desktop so will it work.

Thanks in advance.

Sampath Botla

Re: sending mail using VB Script(Macros)

Anonymous — Wed, 25 Jun 2014 14:41:57 GMT

hmmm

Microsoft office is not istalled there, so it wont work.

Re: sending mail using VB Script(Macros)

Thu, 26 Jun 2014 06:13:59 GMT

Hi Bhumika,

Then how can i run that macro in remote desktop.

Thanks in advance

Sampath Botla