Run a Word Macro from Excel
 

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,
--
Regards,
Rocky McKinley

Run a Word Macro from Excel
 

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

--
Regards,
Rocky McKinley


"Rocky McKinley" wrote in message
...
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,
--
Regards,
Rocky McKinley