Hyperlinks and e-mail

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to send an e-mail as a result of a vlookup. so if I have the name in Col A,the email address in Col B,the case number in Col C and the Vlookup formula on a different page I want to be able to lookup the name and also get the email hyperlink, with the case number included in the subject field. Then I need to automate that process with a Macro..........

Ade
 
Thanks Frank, that tidys up the Macro part, the only issue I now have is when the vlookup runs it pulls through the text but not the hyperlink so I get the email address but not an active link that launches outlook
 
Back
Top