Email Notification through VBA

[Shaza]

Hai, still study on this. Is it possible to send multiple email to same user based on cell value in excel through looping process.
Pleasure if anyone can share your knowledge with me about it.

In one sheets(combination all department listing that need to loop to send email as per department only)
Example:
Dept A-1 email (with 2 value)
Dept B-1 email (with 1 value)

 

[Shaza]

Finally, figure out the way. But once copy excel range value to email body it included along with excel grey line table.
Is it possible to hide line or just view text value only?

 

[daverunt]

You should post the code you are using in order to get any suggestions on how to proceed.

 

[Shaza]

Thanks Daverunt for reply, manage to solve and complete my task already.