Command button to Word Merge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I create a command button on an Access form that will send the information to Word Merge?

The user can click the Tools menu, Office Lins, then select Merge It with MS Word, however they do not want to do this. They wish to click a button that will automatically begin the MS Word Merge.

The next question is that there are several letter formats the user wishes to choose from. Will a different command button be needed for each different letter?
 
Hi DB,

Yes, it can be done. You need VBA code behind the command button that
uses Automation and the Word object model to start up an instance of
Word, create a new document from the appropriate template, and do the
mailmerge.

Almost all of that is Word programming. There's useful information at

http://support.microsoft.com/default.aspx?scid=kb;en-us;209976
http://support.microsoft.com/default.aspx?scid=kb;en-us;159328
and
http://support.microsoft.com/default.aspx?scid=kb;en-us;209882
http://support.microsoft.com/default.aspx?scid=kb;en-us;170988
as well as an Automation white paper at
http://support.microsoft.com/default.aspx?scid=kb;en-us;253235

And of course there's the Word FAQ at http://www.mvps.org/word
 
Albert Kallal has an easy Merge Word sample. Have a look at
http://www.attcanada.net/~kallal.msn/wordmerge/index.html

--
Joan Wild
Microsoft Access MVP

DB said:
How can I create a command button on an Access form that will send the information to Word Merge?

The user can click the Tools menu, Office Lins, then select Merge It with
Click to expand...
MS Word, however they do not want to do this. They wish to click a button
that will automatically begin the MS Word Merge.
The next question is that there are several letter formats the user wishes
Click to expand...
to choose from. Will a different command button be needed for each
different letter?
 
Back
Top