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 - 25 Jul 2007 16:52 GMT
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 - 25 Jul 2007 18:33 GMT
There's always google:
<http://www.google.com/search?q=excel+mailmerge+word
> Hi,
> I've searched the entire Word discussion group to see if I can get something
[quoted text clipped - 7 lines]
> By the way, are there VBA lessons online (trusted websites)?
> Thanks & Regards, Lupe

Signature
Russ
drsmN0SPAMikleAThotmailD0Tcom.INVALID