» Creating email address
CATEGORY: Excel Text Formulas |
VERSIONS: All Microsoft Excel Versions |
Hyperlinking E-mail
Frank wrote on December 31, 1969 18:00 EST
If you add "Mailto:" at the beginning of the CONCATENATE and surround the entire formula with =HYPERLINK, then you can click on the cell and Outlook will create a new message with that person's emial in the To: Line. Also, "&Subject=" will add the subject line and "&Body=" will write part of the e-mail. Add both of these after the e-mail address.
Combine text with formula results
David Briggs wrote on December 31, 1969 18:00 EST
This allowed me to add text before (and after) a lookup formula.
I.E.
=CONCATENATE("Costs for ",VLOOKUP(G24,Table,2,0)," AFTER TEXT")
gave me
"Costs for Southampton AFTER TEXT"
Thanks
Hyperlinking E-mail
GAYATHRI wrote on December 31, 1969 18:00 EST
EXCELLENT.VERY USEFUL
I want to open a new email adress
Pearl B wrote on December 31, 1969 18:00 EST
I want to have an email address. Please create for me
help
stephanie wrote on December 31, 1969 18:00 EST
i desperately need to create an e~mail address so that i can chat
Help please
Martin wrote on December 31, 1969 18:00 EST
I dont know how to create an email adress
formula & function
Jeevan Sarker wrote on December 31, 1969 18:00 EST
Goodday !
I would like to figure out the actual birth date on ms excel.Sometimes i face problems I would like to get soluation from you and the sites by mail.
Plz advise
Jeevan
Book Store:
Recommended Books:
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.






