Exporting Tasks to Excel Spreadsheet including hyperlinks in Notes section !!PLEASE HELP!!

[Glove83]

Hi Everyone,

I really hope someone can help as, if i cant get this, my project will take a huge hit or require a complete rethink.

I am trying to export my tasks from outlook 2010 to excel 2010. The tasks are created from emails a receive via an RSS (drag and dropped). I can export the tasks using the export function but this doesn't take through the hyperlink in the notes section of the task.

I've had some great help from this site before and am hoping you guys can come up trumps for me again.

Thanks,

Gary

 

[Glove83]

After some digging around i found the following code that i use in conjunction with the CodeTwo Outlook exporter.

Sub CreateHyperlinks()


    Dim cell As Range


    For Each cell In Range("G2", Range("G" & Rows.Count).End(xlUp))
        If cell <> "" Then ActiveSheet.Hyperlinks.Add cell, cell.Value
    Next
    
End Sub