troubleshooting Question

Excel hyperlinks - add custom and dynamic text to email body

Avatar of IO_Dork
IO_DorkFlag for United States of America asked on
VBAMicrosoft Excel* hyperlinksMicrosoft Office
2 Comments1 Solution380 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Koen
SDM Mobile

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros