Thread: Macro Security
View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dan
 
Posts: n/a
Default Macro Security

The IT dept has nixed the registry edit mechanism, so, I'll have to use the
OpenDataSource Method. Can I run this method using MS Access VBA or will I
still run into the same problem? I have made a couple initial attempts with
no success. My initial code is as follows:

Set oDoc = GetObject(Forms![frmDocsMain]![Sub]![FilePath], "Word.Document")
oDoc.Application.Visible = True
oDoc.Application.WindowState = wdWindowStateMaximize

If its possible, from here I'm not exactly sure how to proceed with the
OpenDataSource code.



"Cindy M -WordMVP-" wrote:

Hi ?B?RGFu?=,

Yes, I had read this article previously but it is not exactly clear. So, even
though I answer YES to the SQL prompt the merge document will not connect to
its data source? In order to allow the doc to connect I need to edit the
registry as per the article regardless of the macro security level setting?

When you use VBA to open a mail merge document, it cuts off the data source
without prompting. You have basically two choices:

1. Use the OpenDataSource method in your VBA code in order to link the data
source in each time

2. Set the Registry key mentioned in the article so that the SQL prompt is
completely disabled on the machine

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)