Using Application.ActivateMicrosoftApp xlMicrosoftWord

B

billw1829

I'm launching MS Word from Excel and was wondering if there are any arguments
that can be used in the Application.ActivateMicrosoftApp xlMicrosoftWord
expression to automatically execute a letter merge whose form letter and
merge file are already known (and populated).

Am a fair Excel VB programmer but have no experience at all programming Word.
Any tips and/or hints to perform this function will be appreciated.

Thank you -
Bill Wachtenheim
Marlborough, MA
 
J

Jean-Guy Marcil

billw1829 was telling us:
billw1829 nous racontait que :
I'm launching MS Word from Excel and was wondering if there are any
arguments that can be used in the Application.ActivateMicrosoftApp
xlMicrosoftWord expression to automatically execute a letter merge
whose form letter and merge file are already known (and populated).

Am a fair Excel VB programmer but have no experience at all
programming Word. Any tips and/or hints to perform this function will
be appreciated.
Click to expand...

No, I don't think you can have argument in the Activate line that foes that.
In fact, Activate does not take any arguments.

What you can do is start the macro recorder, do the mail merge and then
examine the code you get to clean it up.
For pointers on that, see:
http://word.mvps.org/faqs/macrosvba/UsingRecorder.htm
and
http://word.mvps.org/faqs/macrosvba/ModifyRecordedMacro.htm

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
[email protected]
Word MVP site: http://www.word.mvps.org
 
Top