Hi, I have a simple calculator using a Vlookup function to spit out some numbers. I want to make a calculate button that will generate an email (to me) based on the results of the calculations. I have tried using the hyperlink method as that seemed like it would be simple enough.
I made a hyperlink within a cell below the calculator and filled it with this:
mailto:[email protected]?subject=Check Availability of This Booking&body=b3:f13
This simply put b3:f13 in the body rather than the contents that range represents. How do I do this so I can deliver all the results between b3 and f13.
Bookmarks