Macro to open document

[Lupe]

Hi,
I've searched the entire Word discussion group to see if I can get something
similar to my situation but did not get it. I've created a mailmerge file
with bookmarks. I am still in the testing/updating phase, but later on want
to save it as a template. The source for the merge fields is Excel. I want to
create a macro button in Excel that will open the Word file (template) and
run the merging immediately to a new document. The only thing the users need
to do is save/print the new document. I am using Word 2000.
Hope I was clear enough.
By the way, are there VBA lessons online (trusted websites)?
Thanks & Regards, Lupe

 

[Edward Thrashcort]

I don't have any experience with mail merge so I can't help there.

However, a good way to learn VBA is to record a macro then view the code in
the VBA Editor. Use the VBA context-sensitive online Help to explain the
syntax of commands and the object model

Eddie

 

[Russ]

There's always google:
<http://www.google.com/search?q=excel+mailmerge+word