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
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