Assistance with sending custom emails from Excel

[AlienPump]

Hello everybody,
I have the following sheet (I already posted a topic on this, but I didn't manage to fully resolve this issue, so I am trying it from a different angle):
AlienPumpExampl1.xlsx
I categorize my daily work in rows, I have tickets and I basically write the same "templated" email to everybody.
Perfectly, my idea is to hit the "e" hyperlink and get as much details as possible from the file - so far I have only managed to compose the subject, but there are not enough characters for the body, so this is currently not working for me as I would like it to.
The body would be:

Mr. (D2) {the value from the name column},
Hello, my name is bla bla and I am contacting you in regards to the ticket, about (E2).

...some manual info goes here, that I would write in the email that opened up in Outlook....

Thank you in advance, I am looking forward to your reply.

With regards
bla bla...
tel. bla bla...

I basically have an idea, pertaining to the code, that I might need to use to get the body, to, cc, bcc, subject etc stuff, but I have no idea how to call the command to be executed for the specific row, get the specific info (for example if I want to send an email to Smith, to have his "ticket N" and "Cust. ref" in the Subject and his "name" in the .To field) and resemble the functionality of the =hyperlink, as I have it right now.

If anyone has any ideas on how to accomplish that, please share them with me, I would be extremely grateful!

Thank you in advance.

[WinteE]

I found this on the net.

Please Login or Register  to view this content.

[AlienPump]

@WinteE, thanks for the effort, I appreciate it very much, but do you have any ideas on how would I call this code on the workbook (like I have with the hyperlink)
Do I have to create buttons for each row from the Dev tools, or is it possible to automate this somehow (like it is right now with the hyperlink - I just drag the 1 cell and extend the code from the first line)
I would appreciate any input, thanks in advance

[WinteE]

Supposing you have the email-addresses in column A

Please Login or Register  to view this content.

[AlienPump]

@WinteE, thanks but this doesn't seem to be working.
I am not very knowledgeable in Excel, but I think there is no Sub, I tried to do it myself, but did not manage to get it to work.
Does anybody else have any ideas?
Thanks in advance.

[AlienPump]

Hello all,

Does anyone have an idea as to how I might be able to accomplish the design that I have in mind (having the same functionality as the hyperlink "button", but preferably via VBScript, so that I can include more information in my emails)?

I would appreciate any assistance.
Thanks in advance.