Discussion Board for collaboration on QlikView Scripting.
i was create automail options using macro but suppose any wrong mail id comes my macro was stop. if any give suggestion even wrong mail id comes skip the maill id other mail id mail will generate
You should check the data-structure from the id (min/max lenght, contains @ and domain like .com) and replace special chars like ü/ä/ö or skip then this id.
Thank u for your response.i need permanent solution suppose if any options available in macro it will be better.Present now am removing wrong mailid then only active mailid enable
I meant to make this check and skip in the macro - it are simply string-functions in a extra if-loop.
Not only string suppose every organization if any employee resigned the job that persons mail id be not valid.in this case how can i check in macro
In this case you need of course these information before you executes your mailing - the easiest way is an extra table in loadscript like this:
Load * Inline [
person, mail, valid
x, mail-id, true or false
but better from a database. The macro read this table and only which valid-flag is true will excuted.