+ Reply to Thread
Results 1 to 5 of 5

What is the formula for a multi lined email body derived from =HYPERLINK(CONCATENATE("mail

  1. #1
    Registered User
    Join Date
    01-27-2012
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    33

    What is the formula for a multi lined email body derived from =HYPERLINK(CONCATENATE("mail

    What is the formula for a multi lined email body derived from =HYPERLINK(CONCATENATE("mailto:...

    My current formula is:
    =HYPERLINK(CONCATENATE("mailto: [email protected]&subject="&B2,"&body=Please schedule to install cabinets on: "&TEXT(P23,"mm/dd")),"SAMPLE")

    How do I add additional lines to the email body. Such as:
    1. Please schedule to install cabinets on: DATE (CONCATENATED)
    2. Please schedule to paint cabinets on: DATE (CONCATENATED)
    3. Your purchase orders numbers are: PO'S (CONCATENATED)

    Try it out, play around with it and any help you can offer is GREATLY appreciated.

    Thank you!

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: What is the formula for a multi lined email body derived from =HYPERLINK(CONCATENATE("

    hi JRR007, you just have to join them with ampersand. and the line feed is using "%0A". maybe you can set up a template to make it neater. i have attached a sample and also a write-up i've done recently. hope it helps
    Attached Files Attached Files

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    01-27-2012
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: What is the formula for a multi lined email body derived from =HYPERLINK(CONCATENATE("

    Huge help, that really gives me something to go off. Thank you.

  4. #4
    Registered User
    Join Date
    03-30-2012
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: What is the formula for a multi lined email body derived from =HYPERLINK(CONCATENATE("

    Hello Sir,

    what if i want to do this send message process automated i.e =IF(C9=TODAY(),HYPERLINK("mailto:"&D9&"&subject="&$C$4&"&body="&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($C$5,"$",B9),"@",$C$6),CHAR(10),"%0A"),"send e-mail"),"") automated mail no need to click..


    Thank You

  5. #5
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: What is the formula for a multi lined email body derived from =HYPERLINK(CONCATENATE("

    hi itjockey, it is suggested you start a new thread next time according to Rule No. 2 of the forum
    2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.
    but this might help you:
    http://www.techsupportforum.com/foru...ba-255269.html

+ 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