Depends on what the data source supports. Generally, however, if it's not
Excel or Access you need ODBC. Or an OLE DB provider if Word 2002 or 2003 is
used.
We want to connect to an external source as our secondary data source for
letters in Word, however, my boss does not want users to be able to save the
data anywhere, ie. and Excel spreadsheet or even use Excel in any way.
The question about Research was meant to refer to the Research task pane in
Word - I didn't think there was a connection to mail merge, however, someone
else thought there was a connection.
We need to be able to access the secondary data source from a server without
users being able to save the data source in any way (i.e. as an Excel file)
in the process. Do you think this is possible?
The reference to Research was to the Research task pane in Word. Someone had
suggested it could be used as a secondary data source.
We need to be able to access the secondary data source from a server without
users being able to save the data source in any way (i.e. as an Excel file)
in the process. Do you think this is possible?
Not using mail merge, alone, no. As I said, Word *REQUIRES* its data be savedto
disk.
I'm not sure what you mean by "secondary data source"? But in any case, if you
have data to put into a Word document, and that data can only be held in
memory, then you require a scripting solution to automate Word.
Thanks for your help, Cindy. It is I as thought - I can now confirm this to
my boss.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.