+ Reply to Thread
Results 1 to 2 of 2

hyperlink mailto function, need to take body text from cell

  1. #1
    Forum Contributor
    Join Date
    10-17-2008
    Location
    Vancouver
    MS-Off Ver
    2002 and XP
    Posts
    117

    hyperlink mailto function, need to take body text from cell

    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
    Attached Files Attached Files
    Last edited by kuraitori; 11-12-2008 at 05:35 PM.

  2. #2
    Forum Contributor
    Join Date
    10-17-2008
    Location
    Vancouver
    MS-Off Ver
    2002 and XP
    Posts
    117
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1