topic Re: Send Mail with qlikview. What macro should i use? in QlikView

Send Mail with qlikview. What macro should i use?

Wed, 21 Oct 2015 14:04:10 GMT

Hi!

I have to send a mail with the qlikview.

What macro should i use? I'm trying all the macros but they aren't working and i don't know vb

Thank you

Regards!

Re: Send Mail with qlikview. What macro should i use?

simospa — Wed, 21 Oct 2015 14:09:46 GMT

Hi,

did you take a look here: Sending email from Qlikview ?

Re: Send Mail with qlikview. What macro should i use?

Wed, 21 Oct 2015 14:19:58 GMT

I'm a little confused with the smpt that i have to edit

Can you help me?

What fields should i edit?

Regards

Re: Send Mail with qlikview. What macro should i use?

simospa — Wed, 21 Oct 2015 14:25:29 GMT

SMTP is your mail server for outgoing mail... in the example is used gmail.

Check your smtp in your mail client (Outlook, Thunderbird...) and use it.

Re: Send Mail with qlikview. What macro should i use?

Wed, 21 Oct 2015 14:35:16 GMT

Ok thanks, i knew that! I was saying about all the other fields that i should edit

Cheers

Re: Send Mail with qlikview. What macro should i use?

simospa — Wed, 21 Oct 2015 15:06:05 GMT

What fields don't you undestand? So I can undestand your doubt 🙂

Re: Send Mail with qlikview. What macro should i use?

Wed, 21 Oct 2015 15:22:27 GMT

What fields should i edit to use it ?

Re: Send Mail with qlikview. What macro should i use?

simospa — Thu, 22 Oct 2015 07:35:43 GMT

Jeremias:

$att = new-object Net.Mail.Attachment("C:\temp\imagem.jpg") 'put in there the path of an image if yout want to send it

$att.ContentId = "att"

$smtpServer = "smtp.gmail.com" 'your smtp server

$smtp = new-object Net.Mail.SmtpClient($smtpServer)

$body = 'Image and text<br /><img src="cid:att" />'

$msg = new-object Net.Mail.MailMessage

$msg.From ="name@domain.com.br" 'the email address which will results in From field

$msg.To.Add("name@domain.com") ' the recipient email address

$msg.Subject = 'Text, Image and CC from powershell' ' the subject of your email

$msg.Body = $body '$body will contain the content of your email

$msg.IsBodyHTML = $true 'this set the email format (html/plain text)

$msg.Attachments.Add($att) 'this attache the image

$smtp.Send($msg)

$att.Dispose()

Now is it more clear?

Re: Send Mail with qlikview. What macro should i use?

marcus_malinow — Thu, 22 Oct 2015 10:13:42 GMT

Hi Jeremias,

how are you wanting to send mail? Is this user triggered or automated?

Personally I'd avoid using macros (like the plague)!

Easiest way is just to set up an expression in a straight table like so:

='Send Email' & '<url>mailto:recipient@wherever.com&subject=whatever subject line for ' & only([Dimension])

Then in the expressions display options change the Representation to Link.

Marcus