Hi,
I have created a database in .xls format...
and want to create a Macro in outlook
while macro in excel runs in outlook express.
here not using outlook express thus ..
I have a coding that sends auto reply with specified subject in subject
line..
Here i want the reponce to be sent to many IDs 1 by 1 taking each ID at
a time and send the mail.
e.g. if everyday i want to send a report to many users not including
them in single mail...
can be sent seperatedly...
plz help...
Sub TESTMail(InMail As Outlook.MailItem)
Dim mi As Outlook.MailItem
Set mi = Application.CreateItem(olMailItem)
On Error GoTo ErrorArea
Select Case UCase(Trim(InMail.Subject))
Case "DOCKET"
With mi
.Subject = "RE: Docket Report"
.To = InMail.SenderEmailAddress
.Body = "This is Automated Reply..." & vbNewLine &
vbNewLine & vbcflf & "Hi," & vbCrLf & vbCrLf & "Docket Report
attatched.." & vbCrLf & vbCrLf & "Regards," & vbCrLf & "Puneet Bansal"
.Attachments.Add "C:\Documents and
Settings\puneet\Desktop\Docket Report.xls"
.Send
End With
End Select
Set mi = Nothing
End sub
Bookmarks