Send Mail with qlikview. What macro should i use?

[#1]

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!

[simospa]

Hi,

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

S.

[#3]

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

Can you help me?

What fields should i edit?

Regards

[simospa]

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.

S.

[#5]

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

Cheers

[simospa]

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

S.

[#7]

What fields should i edit to use it ?

[simospa]

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?

S.

[marcus_malinow · Accepted solution]

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