Sure, I get it. I wasn't suggesting that my snippet of code would work for you; I was just showing you what it looks like to write code to create an email, and to populate it with data, from some other Office application. You asked "is it possible?", and I replied "yes, it is—and it looks something like this".
To meet your exact needs you'd have write your own macro. Some of us here would help you develop it, but I thought I'd show you what's involved.
It's probably just a matter of terminology, but let me correct one thing in your description:
Quote:
|
.... i need the email to look along the row (like lookup) and start populating the data for the particular stage....
|
The
email wouldn't do it. Your macro would create the email, then pull the data from the relevant row and put it into the email. Probably that's what you meant; I just wanted to be sure.