Macro to send mail via outlook

Hi, dhammdip17a,

Mail a message to each person in a range will deliver an example for that.

Ciao,
Holger

Hi, dhammdip17a,

Originally Posted by dhammdip17a

but how can i add more rows?

Originally Posted by RDB

The Macro will loop through each row on the Activesheet

Originally Posted by dhammdip17a

and how can i edit a subject for each mail?

Substitute

.Subject = "Reminder"

with

.Subject = "Your order " & Cells(cell.Row, "C").Value

Originally Posted by dhammdip17a

is it possible that i also mention subject in excel file and macro will send that?

Add another column to your data if you feel like the necessity and rely on it. Say the Subject is in Column E

.Subject = Cells(cell.Row, "E").Value

You should check that there is a value in that cell otherwise give some standard subject in an If-Else-Statement.

My name is definitely not Ciao.

HTH,
Holger

Hi, Dhammdip,

donīt worry about my name - I hope you can get along with the information supplied.

Ciao,
Holger