Quote Originally Posted by gmayor View Post
Your first macro goes in the ThisOutlookSession module
The second goes in the Userform code
The variable declaration must go in an ordinary module so it will be seen by both macros.
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...