topic Re: Emailing in QlikView https://community.qlik.com/t5/QlikView/Emailing/m-p/486387#M1149384 <HTML><HEAD></HEAD><BODY><P>can u send the Macro code?</P></BODY></HTML> Wed, 19 Jun 2013 11:48:43 GMT 2013-06-19T11:48:43Z Emailing https://community.qlik.com/t5/QlikView/Emailing/m-p/486386#M1149383 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Im using macro to send Excel files through email</P><P></P><P>the problem is appeared , when the email id is incorrect and it stops there</P><P>In such cases i want to move to next emailId.</P><P></P><P>How can I jump to next email Id record when the previous is incorrect</P><P></P><P>In short I want to identify the correct emailId and inCorrect Email ID in ???</P></BODY></HTML> Wed, 19 Jun 2013 10:52:41 GMT https://community.qlik.com/t5/QlikView/Emailing/m-p/486386#M1149383 2013-06-19T10:52:41Z Re: Emailing https://community.qlik.com/t5/QlikView/Emailing/m-p/486387#M1149384 <HTML><HEAD></HEAD><BODY><P>can u send the Macro code?</P></BODY></HTML> Wed, 19 Jun 2013 11:48:43 GMT https://community.qlik.com/t5/QlikView/Emailing/m-p/486387#M1149384 2013-06-19T11:48:43Z Re: Emailing https://community.qlik.com/t5/QlikView/Emailing/m-p/486388#M1149385 <HTML><HEAD></HEAD><BODY><P>You should check the mail-adress before you run the send statement and if false take the next mail:</P><P></P><P>If(len(mail)) &gt; x and instr(mail, "@') &gt; 1&nbsp; .....</P><P></P><P>Also you could tried with "On error resume next" or react on a specific error message.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 19 Jun 2013 12:13:46 GMT https://community.qlik.com/t5/QlikView/Emailing/m-p/486388#M1149385 marcus_sommer 2013-06-19T12:13:46Z