Automatic CC Entry in Sending Mail

[Sam]

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. (e-mail address removed)) whenever an
e-mail is sent via Outlook? Or, do I have to do that
within Outlook itself?

Sam

 

[Ron de Bruin]

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

 

[keepitcool]

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..



he's our mailing guru here



keepITcool

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