Go4Expert (http://www.go4expert.com/)
-   Visual Basic ( VB ) (http://www.go4expert.com/forums/visual-basic/)
-   -   word hyperlinks (http://www.go4expert.com/forums/word-hyperlinks-t11740/)

catman 30Jun2008 13:22

word hyperlinks
My current challenge is creating a hyperlink in word from two components in Access - the link and the address. I get the merge info into word, by exporting from Access to a TXT document in csv. Then open WORD and merge the doc with the TXT file to create a form letter.

I use this code in a Word MACRO to merge with the doc

Sub CatMerge()
' CatMerge Macro  Macro recorded 3/15/2004 by pmh
    ActiveDocument.MailMerge.OpenDataSource Name:= _
        "C:\catsys\mail\catmergeprop.txt", ConfirmConversions:=False, ReadOnly:=False _
        , LinkToSource:=True, AddToRecentFiles:=False, PasswordDocument:="", _
        PasswordTemplate:="", WritePasswordDocument:="", WritePasswordTemplate:= _
        "", Revert:=False, Format:=wdOpenFormatAuto, Connection:="", SQLStatement _
        :="", SQLStatement1:=""
    With ActiveDocument.MailMerge
        .Destination = wdSendToNewDocument
        .SuppressBlankLines = True
        With .DataSource
            .FirstRecord = wdDefaultFirstRecord
            .LastRecord = wdDefaultLastRecord
        End With
        .Execute Pause:=False
    End With
End Sub

The LINK and the address come over fine. Right now the user has to fiddle about in the newly created document with CTRL + K to make the hyperlink.

Is there any way to do this in code behind the scenes?

cheers Catman

All times are GMT +5.5. The time now is 04:09.