topic Re: Send an object via e-mail with macro? in QlikView

topic Re: Send an object via e-mail with macro? in QlikView https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915804#M981964 <HTML><HEAD></HEAD><BODY><P>Thanks,</P><P></P><P>Ok i think it may be something like this:</P><P></P><P>send the email with an embebed html code</P><P></P><P>Regards,</P></BODY></HTML> Fri, 07 Aug 2015 15:28:57 GMT 2015-08-07T15:28:57Z Send an object via e-mail with macro? https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915800#M981959 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>I have to send every day an e-mail with and object. I know it can be done with a macro, but i tried a few options that i read in the internet and they didn't work.</P><P></P><P>Thank you</P><P></P><P>Regards,</P></BODY></HTML> Fri, 07 Aug 2015 14:48:30 GMT https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915800#M981959 2015-08-07T14:48:30Z Re: Send an object via e-mail with macro? https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915801#M981960 <HTML><HEAD></HEAD><BODY><P>Hi there.</P><P></P><P>Your requirement could be done much better and more professionally using NPrinting.</P><P></P><P>Otherwise you'll have to use the QlikView API to export the object to an image file and then sent that using Outlook.</P><P></P><P>Kind regards,</P><P>Ernesto.</P></BODY></HTML> Fri, 07 Aug 2015 15:02:00 GMT https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915801#M981960 consenit 2015-08-07T15:02:00Z Re: Send an object via e-mail with macro? https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915802#M981961 <HTML><HEAD></HEAD><BODY><P>I think it can be done with macros. Am i wrong?</P><P></P><P>Regards,</P></BODY></HTML> Fri, 07 Aug 2015 15:05:38 GMT https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915802#M981961 2015-08-07T15:05:38Z Re: Send an object via e-mail with macro? https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915803#M981962 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">It CAN be done with macros but that's the hard way of doing things IMHO. You have to be fluent in the VBScript language and know the QlikView object model thoroughly. Besides macros are a very old feature that's being deprecated by Qlik.</SPAN></P><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;"> </SPAN></P><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">Check out this for examples; there's one macro to export to Excel (exporting a chart to JPG or PNG should be done in a similar fashion) and another to send mail using Google.</SPAN></P><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;"><BR /></SPAN></P><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;"><BR /></SPAN></P><P><A href="https://luciancotea.wordpress.com/2013/07/18/qlikview-macros-useful-collection/" title="https://luciancotea.wordpress.com/2013/07/18/qlikview-macros-useful-collection/">QlikView Macros – Useful collection | Lucian Cotea</A></P><P></P><P>Kind regards,</P><P>Ernesto.</P></BODY></HTML> Fri, 07 Aug 2015 15:15:51 GMT https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915803#M981962 consenit 2015-08-07T15:15:51Z Re: Send an object via e-mail with macro? https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915804#M981964 <HTML><HEAD></HEAD><BODY><P>Thanks,</P><P></P><P>Ok i think it may be something like this:</P><P></P><P>send the email with an embebed html code</P><P></P><P>Regards,</P></BODY></HTML> Fri, 07 Aug 2015 15:28:57 GMT https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915804#M981964 2015-08-07T15:28:57Z Re: Send an object via e-mail with macro? https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915805#M981966 <HTML><HEAD></HEAD><BODY><P>i found this </P><P><A href="https://luciancotea.wordpress.com/2013/07/18/qlikview-macros-useful-collection/comment-page-1/#comment-814" title="https://luciancotea.wordpress.com/2013/07/18/qlikview-macros-useful-collection/comment-page-1/#comment-814">QlikView Macros – Useful collection | Lucian Cotea</A></P><P></P><P></P><P>SUB SendMail</P><P>Dim objEmail</P><P></P><P>Const cdoSendUsingPort = 2 ' Send the message using SMTP</P><P>Const cdoBasicAuth = 1 ' Clear-text authentication</P><P>Const cdoTimeout = 60 ' Timeout for SMTP in seconds</P><P></P><P>  mailServer = "<SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;">smtp.gmail.com</SPAN>"</P><P>  SMTPport = 465</P><P>  mailusername = "MyAccount@<SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;">gmail.com</SPAN>"</P><P>  mailpassword = "MyPassword"</P><P></P><P>  mailto = "destination@<SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;">company.com</SPAN>" </P><P>  mailSubject = "Subject line" </P><P>  mailBody = "This is the email body" </P><P></P><P>Set objEmail = CreateObject("CDO.Message")</P><P>Set objConf = objEmail.Configuration</P><P>Set objFlds = objConf.Fields</P><P></P><P>With objFlds</P><P>  .Item("<SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;"><A class="jive-link-external-small" href="http://schemas.microsoft.com/cdo/configuration/sendusing" rel="nofollow" target="_blank">http://schemas.microsoft.com/cdo/configuration/sendusing</A></SPAN>") = cdoSendUsingPort</P><P>  .Item("<SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;"><A class="jive-link-external-small" href="http://schemas.microsoft.com/cdo/configuration/smtpserver" rel="nofollow" target="_blank">http://schemas.microsoft.com/cdo/configuration/smtpserver</A></SPAN>") = mailServer</P><P>.Item("<SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;"><A class="jive-link-external-small" href="http://schemas.microsoft.com/cdo/configuration/smtpserverport" rel="nofollow" target="_blank">http://schemas.microsoft.com/cdo/configuration/smtpserverport</A></SPAN>") = SMTPport</P><P>.Item("<SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;"><A class="jive-link-external-small" href="http://schemas.microsoft.com/cdo/configuration/smtpusessl" rel="nofollow" target="_blank">http://schemas.microsoft.com/cdo/configuration/smtpusessl</A></SPAN>") = True</P><P>  .Item("<SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;"><A class="jive-link-external-small" href="http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout" rel="nofollow" target="_blank">http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout</A></SPAN>") = cdoTimeout</P><P>.Item("<SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;"><A class="jive-link-external-small" href="http://schemas.microsoft.com/cdo/configuration/smtpauthenticate" rel="nofollow" target="_blank">http://schemas.microsoft.com/cdo/configuration/smtpauthenticate</A></SPAN>") = cdoBasicAuth</P><P>.Item("<SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;"><A class="jive-link-external-small" href="http://schemas.microsoft.com/cdo/configuration/sendusername" rel="nofollow" target="_blank">http://schemas.microsoft.com/cdo/configuration/sendusername</A></SPAN>") = mailusername</P><P>.Item("<SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;"><A class="jive-link-external-small" href="http://schemas.microsoft.com/cdo/configuration/sendpassword" rel="nofollow" target="_blank">http://schemas.microsoft.com/cdo/configuration/sendpassword</A></SPAN>") = mailpassword</P><P>  .Update</P><P>End With</P><P></P><P><SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;">objEmail.To</SPAN> = mailto</P><P><SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;">objEmail.From</SPAN> = mailusername</P><P>objEmail.Subject = mailSubject</P><P>objEmail.TextBody = mailBody</P><P>objEmail.AddAttachment "C:\<SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;">report.pdf</SPAN>"</P><P><SPAN class="skimlinks-unlinked" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;">objEmail.Send</SPAN></P><P></P><P>Set objFlds = Nothing</P><P>Set objConf = Nothing</P><P>Set objEmail = Nothing</P><P>END SUB</P></BODY></HTML> Fri, 13 May 2016 23:59:42 GMT https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915805#M981966 everest226 2016-05-13T23:59:42Z Re: Send an object via e-mail with macro? https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915806#M981968 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Thank you I got that to work perfectly but the one thing I can not get to work is to add a str file to the above macro <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P></P><P>How can I add</P><P>'Set the path where the excel will be saved </P><P>     'strDate = Year([Snapshot Date]()) &"-"& month([Snapshot Date]())</P><P>     </P><P>'Save the file and quit excel</P><P>     'curWorkBook.SaveAs "C:\Graphs\Report_"&strDate&".xlsx"</P></BODY></HTML> Tue, 11 Oct 2016 09:35:43 GMT https://community.qlik.com/t5/QlikView/Send-an-object-via-e-mail-with-macro/m-p/915806#M981968 2016-10-11T09:35:43Z