acrosenfeldsmbc
New Member
- Joined
- Dec 1, 2017
- Messages
- 4
Hi,
I am using Lotus Notes.
=HYPERLINK("mailto:"&H119&"?cc=tradecorp@smbcgroup.com&subject=SMBC Deposit Rates "&TEXT(Today_TradeDate,"mm.dd.yyyy")&"&body=B117:F128","SEND")
When I click on the above link, the hyperlink works perfectly. It opens the email in lotus notes and everything looks fine in the subject and cc part.
However, the "B117:F128" part, is data in my excel worksheet that contains Data Points, however, the above link, populates the subject of my email as B117:F128, instead of copying the data and pasting into the body of the email.
Could someone help pls?
Thanks,
I am using Lotus Notes.
=HYPERLINK("mailto:"&H119&"?cc=tradecorp@smbcgroup.com&subject=SMBC Deposit Rates "&TEXT(Today_TradeDate,"mm.dd.yyyy")&"&body=B117:F128","SEND")
When I click on the above link, the hyperlink works perfectly. It opens the email in lotus notes and everything looks fine in the subject and cc part.
However, the "B117:F128" part, is data in my excel worksheet that contains Data Points, however, the above link, populates the subject of my email as B117:F128, instead of copying the data and pasting into the body of the email.
Could someone help pls?
Thanks,
