macro to email
 

Column B contains a name and a command button. I would like the command
button to open a new message and automatically put the name from column B in
the "subject" and the email address from column I in the "to". I may want to
add a cc too (that would be from column D). There will be a button in each
row, and each button will only work for the row it is in. Is there anyone
who can help me with this? Also, column D are only outlook contacts. Is
there a way to have excel automatically recognize everytime I put an outlook
contact in and automatically make it a hyperlink, without having to put the
address in?

Thanks for your help.

macro to email
 

try Ron page

http://www.rondebruin.nl/sendmail.htm

HTH
Regards
Marcelo

"Scott Marcus" escreveu:

Column B contains a name and a command button. I would like the command
button to open a new message and automatically put the name from column B in
the "subject" and the email address from column I in the "to". I may want to
add a cc too (that would be from column D). There will be a button in each
row, and each button will only work for the row it is in. Is there anyone
who can help me with this? Also, column D are only outlook contacts. Is
there a way to have excel automatically recognize everytime I put an outlook
contact in and automatically make it a hyperlink, without having to put the
address in?

Thanks for your help.