hyperlink mailto function, need to take body text from cell
I am working on a hyperlink function that opens up an outlook 2003 email with the subject line and body text taken from specific cells
I am running into the following limitations
1) subject line would include standard text combined with a value taken from another cell (CONCATENATE function). The current formulat I have only takes the standard text but ignores the rest.
2) When I type too much in the body text cell, the error msg #VALUE appears, any idea on what the character limit is for the body text?
I have attached an example worksheet if that will help
Last edited by kuraitori; 11-12-2008 at 05:35 PM.
Solved my own problem,
But for those of you in a similar problem.
1) I had the # symbol in my text string, the mailto function didn't seem to like that (ignored it and the subsequent portion of the text string)
Changed it to No. and it worked fine
2) Seems that the bodytext has a maximum of 189 characters or thereabouts. And currently experimenting with a macro to see if I can work around these limitations
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1