Technically you could write the macro to run in Outlook. Just as you can open Outlook objects in Excel, you can open Excel objects in Outlook. So if you did it in Outlook, your program would open the Excel workbook, ask the user to point out the desired row, pull in the data, create an email and send it.



I agree, though, it seems easier to do it in Excel. You're probably in Excel already, for one thing; and that way the user can, as you say, invoke the program by pointing to the correct row so that the program knows at the start where the data is, instead of having to ask.

So, do you want to start writing this macro with help? Or are you content at this point just to know it's possible, and start making plans for later?