LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Email Macro only sometime works? PaulW Excel Discussion (Misc queries) 0 August 15th 06 10:22 AM
Macro to run on the "Active Sheet" David P. Excel Discussion (Misc queries) 8 April 11th 06 07:42 PM
How can you email a macro from personal.xls Frantic Excel-er Excel Discussion (Misc queries) 2 June 10th 05 07:40 PM
Macro To Email XLS ynissel Excel Discussion (Misc queries) 4 May 26th 05 07:12 PM
Macro - Copy - Email John Excel Worksheet Functions 1 March 2nd 05 07:36 PM


All times are GMT +1. The time now is 01:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"