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

Hi, Dhammdip,

the hyperlink should lead to anything (this is what would be part of the hyperlink address). You could record a macro inserting a hyperlink to get the structure of how to embed it into the table.

Ciao,
Holger

Hi, Mohan,

please do not post you rquestion in the thread of any other member - please start yoour own thread.

Insert Outlook Signature in mail and Mail a different file(s) to each person in a range may help.

Ciao,
Holger