Page 1 of 1

Dit i can do that :) ?

Posted: Sun Feb 05, 2006 10:32 pm
by PowerApe2
Hi .. i wanna know if its possible to make a random Marco..
that always make new Email adressen ( form a databank)
like (1)Tom(2)@(20)
and all the numbers in the (..) will change ramdomly from a file TXT or something else.. so i can always make a new email adresse in the marco
is that possbile ?

Thankx for help... and sorry for my poor english.. i working on it ;)

Posted: Mon Feb 06, 2006 3:42 pm
by Tech Support

the commands in the macro language are not capable of creating random numbers. However through the scripting interface very powerfull languages like VB and even C++ are accessable. The file "random-numbers.vbs" demonstrates how to use a script to generate random numbers and modify the macro based on the outcome. You would need to handle the different parts and the assembling of a new email address in the script and then pass the result on to the macro through the

Code: Select all


Lasse Clausen
iOpus Support

Generate Random Numbers in Excel

Posted: Tue Feb 07, 2006 12:58 pm
by msalperen
You may generate random numbers in Excel (there is such a function in it) and you can use it as an input column in your in your input file for example let column 1 be randomly generated numbers than you can do it as:


here col1 and col 2 should be random columns and col3 maybe your domain name.