Automatic CC Entry in Sending Mail

  • Thread starter Thread starter Sam
  • Start date Start date
S

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
 
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 >
 
Back
Top