Hello,
I am trying to attach multiple files to an automatically generated email through excel 2003
Here is my code for the sending of the email
Sub SendingEmail()
Dim Email_Subject, Email_Send_From, Email_Send_To, _
Email_Cc, Email_Bcc, Email_Body As String
Dim Mail_Object, Mail_Single As Variant
Email_Subject =
Email_Send_From =
Email_Send_To =
Email_Cc =
Email_Body = "Hi All, "
On Error GoTo debugs
Set Mail_Object = CreateObject("Outlook.Application")
Set Mail_Single = Mail_Object.CreateItem(0)
With Mail_Single
.Subject = Email_Subject
.To = Email_Send_To
.cc = Email_Cc
.BCC = Email_Bcc
.body = Email_Body
.display
End With
debugs:
If Err.Description <> "" Then MsgBox Err.Description
End Sub
However, i cant figure out how to add multiple if any to the email and how to automatically insert my signature
Kindly advise
Thanks for your time