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