word hyperlinks

Discussion in 'Visual Basic ( VB )' started by catman, Jun 30, 2008.

  1. catman

    catman New Member

    Jun 30, 2008
    Likes Received:
    Trophy Points:
    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
    Last edited by a moderator: Jun 30, 2008

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice