sending an email from Excel (mailto: vs. VBS)?

big_cizzo

New member
Joined
Mar 27, 2012
Messages
0
Reaction score
0
Points
0
Hello,
I currently have an Excel sheet where I log my daily job activity, I also need to send out a lot of emails, so I am trying to optimize my process.
I have 3 fields of intereset, that I am trying to incorporate into my emails - two ticket numbers and a name (the 2 ticket numbers go into the subject, the name goes to the "To:")
so I already have the mailto: command (i pasted it 1000 times for each row) with the following syntax:
=HYPERLINK("mailto:"&D2&"?subject="&M2&"&body="& N2,"email")

However, my "body" is only limited to about 2 lines of text, which is not enough.

Would anyone be able to assist me with the VB code, that I would have to program, so that I would have a link (button) with the same functionality on every row - composes an email with information, taken from cells within this line in Excel (name and ticket number for the corresponding person)

Thanks in advance to everybody!
Have a great day!
 
Back
Top