View Single Post
  #3   Report Post  
Virgil
 
Posts: n/a
Default

Yes. That's code from the Access VBA using MS Word 9.0
Object Library. Also shoudl have said that the code works
fine in Access 2000. I'll post this problem in the Acess
area.

-----Original Message-----
There's nothing at all in that code that has anything to

do with mailmerge.
Did you post the right code?

Check out the Mailmerge item in the Visual Basic Help

file for details on
how to use vba to execute a mail merge.

--
Please respond to the Newsgroup for the benefit of others

who may be
interested. Questions sent directly to me will only be

answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Virgil" wrote in

message
...
Folks, I'm tearing my hair out trying to find out WHY

this
VBA code doesn't merge data into a Word 2003 template!

The
code is used in an Access 2002 database. The variables

are
fine. It creates an active document from a template but
it does NOT merge the data.

With gappWord
.Selection.WholeStory
.Selection.Fields.Update
.Selection.HomeKey Unit:=wdStory
.ActiveDocument.SaveAs gstrJobsheetsPath &

strNewFileName
.Visible = True
.ActiveWindow.WindowState = wdWindowStateMaximize
.Activate
End With



.