SendMail

[janet]

Using office 97

I have worked more often in Excel then Word with VBA and
have always been able to send an e-mail from the program
that would automatically address, cc, and put in a subject

coding looked something like this:

Sheets("Rate Request Sheet").Select
ActiveWorkbook.SendMail Recipients:=Range("AA15"),
Subject:=Range("aa17")
MsgBox "Rate Request Sent"

I have tried to figure out the Word syntax but I am not
having any luck. Is it possible to do this in Word? If
so, how?

 

[Doug Robbins - Word MVP]

Hi Janet,

See the article "How to send an email from Word using VBA" at:

http://www.mvps.org/word/FAQs/InterDev/SendMail.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP