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
' 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 _
.Destination = wdSendToNewDocument
.SuppressBlankLines = True
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
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?