Email VBA Code

[jaypatel]

Hi,

I have the following macro:

Private Sub cmdFinish_Click()
AllFormsUnload
ActiveWorkbook.SaveAs Filename:="F:\Project Proformas" & Range("title").Value & ".xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
On Error Resume Next
Application.Dialogs(xlDialogSendMail).Show _
arg1:="jaypatel@c-plex.co.uk", _
arg2:="Project Proforma"
If Err <> 0 Then
MsgBox "Sorry, an error has occured, please notify blah@blah.co.uk"
End
End If
End Sub


with the above:

Arg1 is for "To"
Arg2 is for "Subject"

I need help as to the what the code for the "cc" section.
I am using Microsoft Outlook.

Jay

[vass0922]

do you have to use CC?
You could just use ; as a delimiter between email addresses if its outlook....

[cowboybooter]

Welcome to TechIMO,


I was gonna say it's above me, you need a guy called Vass0922, the VB Guru around here, But I guess I won't now!





CBB