macro to email

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top