We help IT Professionals succeed at work.
Get Started

Excel hyperlinks - add custom and dynamic text to email body

Last Modified: 2017-04-11
Is there a way to generate hyperlinks in cells F10:F500 so that each hyperlink, when clicked, will create a new email that not only contains the recipient "me@myfirm.com", and the subject "Trade Order", but also populates the body of the email with a 4x2 table and inserts the contents of the current cell into the first row, second column? see screenshot below. I assume this would be done with vba?

email with dynamic data
If table is not an option, I would be happy with just being able to embed the email body with the contents of the cell that the hyperlink is associated with. For Example, If there is a hyperlink on F2 then when it is clicked on, it will produce an email with the following string in the body {02006LZ97 corp des <go>}, the part that is bold is dynamic (it's the contents of the cell that the hyperlink is associated with).

Also, if any of this is possible, will the custom hyperlinks work when the excel file is saved as a PDF?
Watch Question
SDM Mobile
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE