Have an Access database that displays a list of Word Doc hyperlinks that are mail merge documents. The docs are merged to a table in the .mdb that is created from the client record that is currently being viewed. AutoOpen macro in these Word docs merge to new doc, then close original.
These have worked fine in 2003, with hyperlink security and SQL warnings off. Am now in 2010.
They work fine if browsed to and opened through Explorer but I cannot get rid of securtiy warning messages in 2010 when they are opened via the hyperlink in the db.
In Access and Word I have enabled macros, put the db and doc location in as trusted locations, unchecked everything else to do with opening docs from links etc. etc.
And another funny thing, they open twice when I clcik through the warnings!!, but I only end up with one of them on screen. I always end up at Letters 2, then Letters 4, then Letters 6. When I go to log off the TS I have to close Letters 1,3 and 5 which arent even visible!
Simple code in Word doc:
' AutoOpen Macro
' Used in ResolveIT Mail Merge to automaticlly merge to new document On Open
.Destination = wdSendToNewDocument
.SuppressBlankLines = True
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord