acrosenfeldsmbc
New Member
- Joined
- Dec 1, 2017
- Messages
- 4
Hello All,
I currently use Lotus Notes.
Currently, the below formula opens an email, and inserts correctly the TO: and the CC part.
=HYPERLINK("mailto:"&JANE&"?cc=Joe@ABC.com&subject=Interest Rates "&TEXT(Today_TradeDate,"mm.dd.yyyy")&"&body=B117:F128","SEND")
In addition to that, I have data that I need to COpy and Paste, Cell A1:B5 into the body of the email, but it does not insert.....
The B117:F128 is where I have the data I want to copy and paste....
The above does not work
Can someone assist pls!
Thank you
I currently use Lotus Notes.
Currently, the below formula opens an email, and inserts correctly the TO: and the CC part.
=HYPERLINK("mailto:"&JANE&"?cc=Joe@ABC.com&subject=Interest Rates "&TEXT(Today_TradeDate,"mm.dd.yyyy")&"&body=B117:F128","SEND")
In addition to that, I have data that I need to COpy and Paste, Cell A1:B5 into the body of the email, but it does not insert.....
The B117:F128 is where I have the data I want to copy and paste....
The above does not work
Can someone assist pls!
Thank you