Prev: Adding data from multiple worksheets of the same type
Next: Excel 2003 + script to open and automatically close an excel workb
From: Neil Holden on 4 Mar 2010 05:36
I have set up a button and when pressed it will send to specific people,
below is the code I have, what i need it to do now is whoever sends the email
i want that user automatically CC into the email? Is this possible?

Thanks.

On Error Resume Next
With OutMail
.To = "neil.holden(a)test.com; david.cope(a)test.com"
.CC = ""
.BCC = ""
.Subject = "Contract Created"
.Body = strbody
.Send 'or use .Display
End With
On Error GoTo 0

Set OutMail = Nothing
Set OutApp = Nothing
Application.DisplayAlerts = True
Application.ScreenUpdating = True
 | 
Pages: 1
Prev: Adding data from multiple worksheets of the same type
Next: Excel 2003 + script to open and automatically close an excel workb