+ Reply to Thread
Results 1 to 7 of 7

Hyperlink email using cell value as subject with mailto function

  1. #1
    Registered User
    Join Date
    03-15-2014
    Location
    portugal
    MS-Off Ver
    Excel 2003
    Posts
    61

    Hyperlink email using cell value as subject with mailto function

    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.

  2. #2
    Registered User
    Join Date
    09-13-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: Hyperlink email using cell value as subject with mailto function

    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.

  3. #3
    Registered User
    Join Date
    03-15-2014
    Location
    portugal
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: Hyperlink email using cell value as subject with mailto function

    Doesn't work, i get the message: "this formula contains an error"


    Quote Originally Posted by in.vaibhav View Post
    Hi

    You can do by:

    =HYPERLINK("mailto:[email protected]?subject="&A1,"email me")

    where cell A1 contains your subject line..

    Cheers!!

  4. #4
    Registered User
    Join Date
    09-13-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: Hyperlink email using cell value as subject with mailto function

    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..

  5. #5
    Registered User
    Join Date
    03-15-2014
    Location
    portugal
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: Hyperlink email using cell value as subject with mailto function

    malito.xlsx

    Here is the sample.

    I use MACOSX.



    Quote Originally Posted by in.vaibhav View Post
    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..

  6. #6
    Forum Contributor
    Join Date
    06-24-2005
    Location
    excelliot.com
    MS-Off Ver
    2007
    Posts
    325

    Re: Hyperlink email using cell value as subject with mailto function

    Check this attachment..

    Cheers!!
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    03-15-2014
    Location
    portugal
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: Hyperlink email using cell value as subject with mailto function

    Thank's for help.

    Subtitle worked but not body multiple lines.

    Do you know how to do it?

    I tried with %0A

    Quote Originally Posted by excelliot View Post
    Check this attachment..

    Cheers!!

  8. #8
    Registered User
    Join Date
    03-15-2014
    Location
    portugal
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: Hyperlink email using cell value as subject with mailto function

    Someone know's how to do it?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-17-2013, 01:48 AM
  2. MAILTO hyperlink email issue
    By Nans434 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-25-2012, 01:00 PM
  3. VBA Excel 2003 Alter Subject Under Hyperlink Mailto:
    By november84 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-01-2011, 05:11 AM
  4. Excel 2007 : In mailto, add a subject from a cell
    By furiousfox in forum Excel General
    Replies: 2
    Last Post: 03-18-2009, 03:28 AM
  5. hyperlink mailto function, need to take body text from cell
    By kuraitori in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-12-2008, 05:35 PM

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