Hi All,
If I could get some assistance with a Hyperlink formula;
I am attempting to setup a Hyperlink to send contents of multiple cells into a Message on the Cisco Jabber App, "IM:[email protected]" opens the jabber program with the person added.
currently use a hyperlink to send certain cells contents to Mail, we recently changed to Jabber, and wouldn't mind having this work for IM)
=IFERROR(HYPERLINK("mailto:"&O54&"?subject="&C54&" - "&D54&"&body="&F54&" - Maximo "&G54&"","Email WO"), "Notes too large, Temp remove some txt to send")
So far this works, But I was wondering if I am able to send contents of cell as the message:
=HYPERLINK(CONCATENATE("IM:",O60))
As "IM:[email protected]" opens the jabber App. is there any way to send a particular cells value as the message
I understand concatenate may not be the correct formula to use,
Any assistance would be Great.
Thanks, Drew
Bookmarks