topic Macro (Variable retrieval in macro) in QlikView https://community.qlik.com/t5/QlikView/Macro-Variable-retrieval-in-macro/m-p/518322#M193566 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Please refer to the attached file,</P><P>In this&nbsp; I have few variables which I want to us in macro, but the macro gives an error of Object required.</P><P></P><P>Kindly help me out....</P></BODY></HTML> Wed, 13 Nov 2013 13:10:23 GMT 2013-11-13T13:10:23Z Macro (Variable retrieval in macro) https://community.qlik.com/t5/QlikView/Macro-Variable-retrieval-in-macro/m-p/518322#M193566 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Please refer to the attached file,</P><P>In this&nbsp; I have few variables which I want to us in macro, but the macro gives an error of Object required.</P><P></P><P>Kindly help me out....</P></BODY></HTML> Wed, 13 Nov 2013 13:10:23 GMT https://community.qlik.com/t5/QlikView/Macro-Variable-retrieval-in-macro/m-p/518322#M193566 2013-11-13T13:10:23Z Re: Macro (Variable retrieval in macro) https://community.qlik.com/t5/QlikView/Macro-Variable-retrieval-in-macro/m-p/518323#M193567 <HTML><HEAD></HEAD><BODY><P>Hello Nitin,</P><P>Check below changes and then try... Below are the all the setting you will need</P><P></P><P>'SMTP server details</P><P>.Item("<A href="http://schemas.microsoft.com/cdo/configuration/sendusing">http://schemas.microsoft.com/cdo/configuration/sendusing</A>") = <STRONG>2</STRONG></P><P>.Item("<A href="http://schemas.microsoft.com/cdo/configuration/smtpserver">http://schemas.microsoft.com/cdo/configuration/smtpserver</A>") = <STRONG>"YOUR SMTP SERVER NAME"</STRONG></P><P>.Item("<A href="http://schemas.microsoft.com/cdo/configuration/smtpserverport">http://schemas.microsoft.com/cdo/configuration/smtpserverport</A>") = <STRONG>25</STRONG></P><P>.Item("<A href="http://schemas.microsoft.com/cdo/configuration/smtpusessl">http://schemas.microsoft.com/cdo/configuration/smtpusessl</A>") = <STRONG>false</STRONG></P><P>.Item("<A href="http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout">http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout</A>") = <STRONG>120</STRONG></P><P>...</P><P>...</P><P>objEmail.To = ActiveDocument.Variables("varTo").GetContent.String</P><P>objEmail.Cc = ActiveDocument.Variables("varCC").GetContent.String</P><P>objEmail.From = ActiveDocument.Variables("varFrom").GetContent.String <EM>'This could also be a variable</EM></P><P>objEmail.Subject = ActiveDocument.Variables("varSubject").GetContent.String</P><P>objEmail.TextBody = ActiveDocument.Variables("varBody").GetContent.String</P><P>&nbsp; </P><P>Thanks,</P><P>Robinson</P></BODY></HTML> Wed, 29 Jan 2014 08:07:44 GMT https://community.qlik.com/t5/QlikView/Macro-Variable-retrieval-in-macro/m-p/518323#M193567 2014-01-29T08:07:44Z