E-mail file through macro

  • Thread starter Thread starter Janet
  • Start date Start date
J

Janet

When using excel, if I wanted to send a file from a macro
I would script it something like this:

Sub SendRequestToCO()
Sheets("Rate Request Sheet").Select
ActiveWorkbook.SendMail Recipients:= Range
Subject:= range
MsgBox "Request Sent to ????"


Being new to creating the macro in Word, I converted it to
the following but this does not work.

ActiveDocument.SendMail
Recipients:[email protected] , subject: ="Rate
Request"

Please help!
 
Back
Top