Notes mail with Hyperlinks in Excel

[vaneujl]

Hi,

I would like to create and send a Notes message using Excel VBA that is including Hyperlink instead of using attachments.
I have yet been able (thanks to Tek-tips) to create a Notes message with attachments and send it to people but this is an heavy solution for the Notes Server disk space. I would prefer to have some hyperlinks included in the text body of the message. So, what code should I use to identify some characters in the body text as hyperlink?

Thanks in advance for your help

 

[xlbo]

I presume that part of your code has a variable that holds the "body" of the email
Try creating a hyperlink within excel (concatenated with any other necessary text) and pick that up using a cell reference to assign it to the "body" variable. This works in outlook so it may also work for Notes Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[vaneujl]

Hi Geoff,

I tried the following body text variable setting.
bodytext = Sheets("Sheet1&quot.Range("A1&quot.Value
The cell A1 in Sheet1 was containing the hyperlink.
Unfortunately, this doesn't work.
The hyperlink address has been considered as text in the Notes message.

Other ideas?

Thanks, J-L

 

[xlbo]

Was it set up as a hyperlink in excel (insert>hyperlink) or was it just typed in the form of a hyperlink ??

If you inserted a hyperlink and it still doesn't work then I'm afraid I'm out of ideas

I would use the TEXT property of the cell tho rather than the value Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[vaneujl]

Hi Geoff,

the content of the cell A1 was yet a hyperlink in my previous test. So, we have to fing another way.

Anyway, thanks for your help.

Best regards, J-L