View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Macro to email with "active row" info

Hi Scott

You can start here
http://www.rondebruin.nl/mail/folder3/mail4.htm

Ho do you name your checkboxes in each row
Do you incuode the row number in the name ?


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Scott Marcus" wrote in message ...
I would like to create a macro that would open a new email message with
information from the active row. I also want to incorporate check boxes into
the macro so that if one check box is ticked, then the "To:" would only be
cell E from the active row, if the other check box is ticked, then the "To:"
would be only cell H from the active row, and if both check boxes are ticked,
the the "To:" would be both cell E and cell H from the active row. The
subject would always be cell C from the active row. Is that possible?