Hello again,
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
Bookmarks