E-mail file through macro

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!
 
L

lizabeth%abac.com

Sorry, but I am test fishing for the worm that is coming via this newsgroup
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top