Run a Word Macro from Excel

  • Thread starter Thread starter Rocky McKinley
  • Start date Start date
R

Rocky McKinley

Hi I need to run a a word procedure from Excel:
MacroName: "letter1"
Procedure Location: "Normal"
Document Name: "ActiveDocument"

Word will already be active with a new Email, addresses, subject already
filled in. I just need to call "letter1" to insert formatted text in the
body of the message.

Thanks in advance,
 
I found the answer on Google...

'RUN A WORD MACRO FROM EXCEL WHEN WORD IS ACTIVE
Set WdApp = Word.Application
With WdApp
.Application.Run MacroName:="Normal.NewMacros.letter" & Ans
End With
 
Back
Top