topic Re: wrong Mail id to be skip in QlikView

wrong Mail id to be skip

pandiarajan — Tue, 27 Aug 2013 09:12:05 GMT

Dear all,

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

Re: wrong Mail id to be skip

marcus_sommer — Tue, 27 Aug 2013 10:07:20 GMT

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.

- Marcus

Re: wrong Mail id to be skip

pandiarajan — Wed, 28 Aug 2013 07:28:03 GMT

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

Re: wrong Mail id to be skip

marcus_sommer — Wed, 28 Aug 2013 07:43:49 GMT

I meant to make this check and skip in the macro - it are simply string-functions in a extra if-loop.

- Marcus

Re: wrong Mail id to be skip

pandiarajan — Wed, 28 Aug 2013 07:46:16 GMT

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

Re: wrong Mail id to be skip

marcus_sommer — Wed, 28 Aug 2013 07:59:36 GMT

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:

mail:

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.

- Marcus