Hello,
I have a database and I want to pass some varables to Word to merge. The way
I have it on my machine is I have a Macro and I pass some varables to alter
the Macro.
However, to do this for everyone I would need to install the Macro on every
machine or every document.
What I was wondering is would it be ok to pass all the SQL statement from
the database to word to save setting up the Macro on every machine in the
office? Its not a big statement (just usual mail merge code) but would it
slow the opening of the document up?

Many thanks, James

Hi:

What you could do is put your Word Macro code as part of Access VBA code and
set a refernce to Word. This way you do not need to run a Word Macro.

You could instantiate Word like this --

Dim objWord as Word.Application 'Make a reference to "Microsoft Word Object
Library"
On error resume next
Set objWord = GetObject(,"Word.Application") 'checks for running instance of
Word
if objWord is Nothing then
Set objWord = CreateObject("Word.Application") 'if Word not running
instantiate new copy
objWord.Visible = True 'New instnace of Word must be made visible
end if
On error goto 0

With objWord
'Put your macro code here
'preface word objects in code with objWord here like
objWord.ActiveDocument
End With

Hope this helps.

Regards,

Naresh Nichani
Microsoft Access MVP


"James" <(E-Mail Removed)> wrote in message
news:C3F44381-CDE7-401D-A227-(E-Mail Removed)...
> Hello,
> I have a database and I want to pass some varables to Word to merge. The
way
> I have it on my machine is I have a Macro and I pass some varables to
alter
> the Macro.
> However, to do this for everyone I would need to install the Macro on
every
> machine or every document.
> What I was wondering is would it be ok to pass all the SQL statement from
> the database to word to save setting up the Macro on every machine in the
> office? Its not a big statement (just usual mail merge code) but would it
> slow the opening of the document up?
>
> Many thanks, James

Perhaps you might give my ms-access to word template system a try.

It enables to you merge the current record you are looking at to a word
template. And, the merge system is NOT hard coded to any field name...so it
will work with your existing applications. You can give the sample a try
here:

http://www.members.shaw.ca/AlbertKal.../msaccess.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.members.shaw.ca/AlbertKallal

Hi,
Thanks for your reply.

I have done what you say below, but unless I start word first it says
"ActiveX component can't create object".

It works when I open a new document in word and then click the button but it
comes up with the error "Word could not merge the main document with the data
source because the data records were empty or no data records matched your
query options." but then it merges perfectly.

Any suggestions?

"Naresh Nichani MVP" wrote:

> Hi:
>
> What you could do is put your Word Macro code as part of Access VBA code and
> set a refernce to Word. This way you do not need to run a Word Macro.
>
> You could instantiate Word like this --
>
> Dim objWord as Word.Application 'Make a reference to "Microsoft Word Object
> Library"
> On error resume next
> Set objWord = GetObject(,"Word.Application") 'checks for running instance of
> Word
> if objWord is Nothing then
> Set objWord = CreateObject("Word.Application") 'if Word not running
> instantiate new copy
> objWord.Visible = True 'New instnace of Word must be made visible
> end if
> On error goto 0
>
> With objWord
> 'Put your macro code here
> 'preface word objects in code with objWord here like
> objWord.ActiveDocument
> End With
>
> Hope this helps.
>
> Regards,
>
> Naresh Nichani
> Microsoft Access MVP
>
>
> "James" <(E-Mail Removed)> wrote in message
> news:C3F44381-CDE7-401D-A227-(E-Mail Removed)...
> > Hello,
> > I have a database and I want to pass some varables to Word to merge. The
> way
> > I have it on my machine is I have a Macro and I pass some varables to
> alter
> > the Macro.
> > However, to do this for everyone I would need to install the Macro on
> every
> > machine or every document.
> > What I was wondering is would it be ok to pass all the SQL statement from
> > the database to word to save setting up the Macro on every machine in the
> > office? Its not a big statement (just usual mail merge code) but would it
> > slow the opening of the document up?
> >
> > Many thanks, James
>
>
>