Thanks gmayor.... i want to capture the subject of email using the first macro... and pass it to userform code... so how can i define the variable in ordinary module.. can u provide a sample... if i create a ordinary module, will the script get triggered when a mail is sent?
please help...