Hi.
I want to use a cell value as email subject
i tried a few tips but non worked.
Also i would like to add a body for the email and i succeed doing it but i can't use multiple lines, i tried %0A%0 and %0A but didn't work.
Hi.
I want to use a cell value as email subject
i tried a few tips but non worked.
Also i would like to add a body for the email and i succeed doing it but i can't use multiple lines, i tried %0A%0 and %0A but didn't work.
Hi
You can do by:
=HYPERLINK("mailto:[email protected]?subject="&A1,"email me")
where cell A1 contains your subject line..
Cheers!!
Last edited by in.vaibhav; 05-19-2014 at 11:27 AM.
Hi
This is an example, you need to paste this formula in cell, click on that cell to create email.
Or else upload sample sheet..
malito.xlsx
Here is the sample.
I use MACOSX.
Check this attachment..
Cheers!!
Someone know's how to do it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks