What is the formula for a multi lined email body derived from =HYPERLINK(CONCATENATE("mailto:...
My current formula is:
=HYPERLINK(CONCATENATE("mailto: name@Company.com&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!
My current formula is:
=HYPERLINK(CONCATENATE("mailto: name@Company.com&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!
