Automatic CC Entry in Sending Mail
 

Is there a VBA procedure that I can use in one Office
product (Word, Excel, etc) that will instruct Outlook to
automatically CC (i.e. ) whenever an
e-mail is sent via Outlook? Or, do I have to do that
within Outlook itself?

Sam

Automatic CC Entry in Sending Mail
 

I have examples on my website Sam
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Sam" wrote in message ...
Is there a VBA procedure that I can use in one Office
product (Word, Excel, etc) that will instruct Outlook to
automatically CC (i.e. ) whenever an
e-mail is sent via Outlook? Or, do I have to do that
within Outlook itself?

Sam

Automatic CC Entry in Sending Mail
 

Sam,

The Workbooks.Sendmail method only allows setting the TO field.

BUT if you're sending the worksheet.. THEN this would work

Sub SendSheet()
With ActiveSheet
With .MailEnvelope
With .Item
.TO = "email1;email2"
.CC = "email3;email4"
.BCC = "email5;email6"
.Subject = "This sheet concerns..subject"
End With
.Parent.EnvelopeVisible = True
.Introduction = "This is the intro line..."
'.Send
End With
End With
End Sub

for LOTS more stuff re excel and outlook you must visit
a fellow countryman of mine..

www.rondebruin.nl

he's our mailing guru here :)



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Sam" wrote:

Is there a VBA procedure that I can use in one Office
product (Word, Excel, etc) that will instruct Outlook to
automatically CC (i.e. ) whenever an
e-mail is sent via Outlook? Or, do I have to do that
within Outlook itself?

Sam