I'm wondering if anyone can direct me to an excel macro that generates form emails from the fields of a spreadsheet. This should be pretty simple, but I'm trying to save time by working from a template. The only thing I'm not sure how to do is make it look up the recipient's name in my firm's global address book. Any help would be appreciated.
Thanks,
Zach