Hello, this is my first post here. Wonderful site you got going here.
My problem is this:
I work for a Medical journal and we are keeping all of our records in an Excel file. (I would rather it in a database, but this being a large company we have to work with what we got). So, I have a rather large worksheet with contacts, email addresses, various dates, and other random stuff that I need to keep track of. Now I have to add a new record when a new paper comes in, then update it when I get revisions and such. Everytime I get some new information I need to email the Author to inform them we have the info.
What I would like to do is to write a nice little (ok it will probably be long) formula that will grab fields in that row and add them to an formula. Then I can click that cell and an email will pop up and I can just check it for accuracy before I push send. I would probably have one of these for every row.
So lets say I have a Reference Number in Col A, The email address in Col B, and The persons name in Col C. Is it possible to use the HYPERLINK=("mailto:Col B?subject=Submission Ref Number+ "Col A":?body=Hello+" Col C",friendly_name )
Now, I am pretty sure that my syntax is off but I hope that my question comes across clear.
As a note, the reason I am doing it using the mailto and not exploring a VB route is that I don't have access to VB here at work.
Thanks for the help,