ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003 - emailing (https://www.excelbanter.com/excel-discussion-misc-queries/257945-excel-2003-emailing.html)

Neil Holden

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


All times are GMT +1. The time now is 02:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com