Solved: Hyperlink to OneNote Notebook Problem

[Cora419]

I've created an Excel file where the user copies a hyperlink to a OneNote Notebook and inserts it into a cell in Excel. When a button is clicked in the Excel file, the code grabs the hyperlink address from the cell and assigns it to a variable. An Outlook email is generated which inserts the hyperlink address between < >.

This works fine, but the problem is that the hyperlink address from OneNote begins with "onenote:http" which is not recognized as a link by Outlook. Are there additional characters I need to add to this link to make it work? Is there another way to get the link into the Outlook message? The link does work on the Excel form but not when the full address is transferrred to Outlook.

I'm using OneNote 2007 on a SharePoint Server and Excel and Outlook 2003.

Any help you could provide would be greatly appreciated!!

[Cora419]

I figured this out -- I just used .htmlBody instead of .body in the email. The hyperlink address from Excel works with href and html tags. It also gave me the ability to format the email text which I couldn't do with plain text.

Thanks