I have a list of contacts in Excel grouped by Sales market, Business Unit, and First Last Name but some of the name boxes have multiple names.
What I want to be able to do is click on the name box and have one of 3 default templates (currently in Word) pop up in Outlook to the people in that box. I have to add things to the template, so I don't think Send Mail will work.
Furthermore, it has to work in reference because I'm returning the values of those boxes via VLOOKUP to an actual sheet that I'm working from that tells me what data I need to send. Any help appreciated.
What I want to be able to do is click on the name box and have one of 3 default templates (currently in Word) pop up in Outlook to the people in that box. I have to add things to the template, so I don't think Send Mail will work.
Furthermore, it has to work in reference because I'm returning the values of those boxes via VLOOKUP to an actual sheet that I'm working from that tells me what data I need to send. Any help appreciated.