hi all,

I was hoping you could help me with the code for the following:

(Sheet 1)
I select B23 / 24 / 25.... etc
macroassignedbutton_click to do the following:

Find corresponding email address in O23 / 24 / 25....
Open embedded object (on Sheet 4) thanks.msg
Paste email address into To: field of outlook msg
Send automatically(?)
Insert "msg sent" into Q23 / 24 / 25....

display message box to confirm action is complete

eagerly awaiting your help!

many thanks