Automated email from MS Excel on press of a button?

Eg. In Line 1; in field A1 we have a Number like 12345. In A2 we have an email address like xyz@abc.com. In A3 we have a button. Now when we will click the button automatically system should mail the data present in A1 to the email address present in A2. Now this button will be available in each line. %26amp; the corresponding data must be picked up. Eg. In line 3 button pressed in C3 will pick up data from C1 %26amp; mail to address in C2.
Automated email from MS Excel on press of a button?
Instead of a button, you could have a hyperlink that includes the Email address, a email Subject, and your value from row 1 in the body.





Try this in A3 instead of a button


=HYPERLINK("mailto:"%26amp;A2%26amp;"?subject=


Excel email %26amp; body=Value from Row1


="%26amp;A1,"Email: "%26amp;A2%26amp; " This value: "%26amp; A1)





(The formula should all be on one line)





mailto:"%26amp;A2


A2 is the Email address to send to





subject=Excel email


The Subject of the email. In this case "Excel Email". You can make it what you want.





body=Value from row 1 ="%26amp;A1


The text in the body of the email. In this case, "Value from Row1 = 12345". Again, you can make it what you want.





"Email: "%26amp;A2%26amp; " This value: "%26amp; A1


What you want displayed as the link in Excel.