catman's Avatar, Join Date: Jun 2008
Newbie Member

Great to a find a free site! I am fed up with signing up for expert help and then finding that that they don't know much, and then worse still not being able to cancel the monthly subcription.

Catman is the name given to me by one of the UK users of the CAT commercial property agency system. I do stuff in Access DAO linking through to Word and Outlook.

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 work, by exporting from Access to a TXT document in csv. The open WORD and merge the doc with the TXT file to vreate 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 shabbir; 30Jun2008 at 13:31.. Reason: Code block
coderzone's Avatar, Join Date: Jul 2004
Team Leader
wrong forum