View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Holden Neil Holden is offline
external usenet poster
 
Posts: 163
Default Excel 2003 - emailing

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 = ; "
.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