Hyperlinks and e-mail

[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

 

[Frank Kabel]

Hi
not quite sure this is what you want but for mailing macros have a look
at Ron's site:
http://www.rondebruin.nl/sendmail.htm

 

[Guest]

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

 

[Frank Kabel]

Hi Ade
you may try something like
=HYPERLINK(your_vlookup_formula)

 

[Guest]

It gives me a message "cannot open specified file" thansk for the suggestion Frank