How can commandbuttons sent via excel vba, be made to work in outlook?

Hello There,
I have a process which sends rows from excel to outlook and tried adding commandbuttons that when clicked will generate an email reply with some custom text. The user then has to click 'reply' to send. The commandbuttons arrive as images. Is it a possible to get them to work in outlook?

I am definitely closer to getting the result I am looking for. The pictures have been added and a hyperlink with my email address does generate an email. What I would also like to see is the original subject. I don't want to have to type the subject in the hyperlink every time- as it changes. Is there a way to have the subject as sent in the outlook email automatically populate the hyperlink generated reply?

Did more searching to try and resolve my issue....added picture and added hyperlink formula for sending email plus custom subject and my last step is to add myexcel header and a of columns.


Body text has to be a combination of $C$1 & C2:O2. I have tried entering ...."&body"=&C$1& &C2:O2, "NO") but that didn't work..any help would be appreciated

=HYPERLINK("mailto:[email protected]"&"?subject="&F2&"_Vote Deadline_ "&TEXT(L2,"MM/DD/YYYY"),"NO")

Correction this is what I have tried and it does not work at all I get the "VALUE error

=HYPERLINK("mailto:[email protected]"&"?subject="&F1&"_Vote Deadline_ "&TEXT(L1,"MM/DD/YYYY")& "&body=" &$C$1&C2:O2, "NO")

So I don't know how to get commandbuttons sent via excel to run my vba so as suggested as a workaround, here is my completed hyperlink. My process is I send a row via an excel macro and the recipient selects one of 2 hyperlinks from outlook that generates an email response to me with a (plaintext) subject and body taken from my excel spreadsheet in addition based on their selection, there is custom text.

I added several cells after ["&TEXT(L1,"MM/DD/YYYY")&] and started a new line for the body of my email response for "Notes:". For those of you interested and find this thread meaningful..FYI "VOTE WITH" at the end is the link name that is visible:

=HYPERLINK("mailto:[email protected]"&"?subject=Vote "&C1&" Deadline "&TEXT(M1,"MM/DD/YYYY")&"&body=Vote With "&C2&" "&G2&" "&O2&" Meeting "&TEXT(K2,"MM/DD/YYYY")&"%0ANotes: ","VOTE WITH")