Help needed with loop - sending attachment in lotus notes

Morning,

I am having a little trouble looping code to send an email with attachment in lotus notes.

I can get it to work, to do one. But it's the whole looping thing I am unsure on (New to VBA)

The code below works to send an email with attachement from file path that is specified in D5 and sends to the email recipient specified in E5, those two bits of information I want changing to go down the list, so next one I want to be D6 and E6 and so on until I get to bottom of list.

Would really appreciate any help anyone can provide...

Please Login or Register  to view this content.

Appreciate your reply...but It is the loop part of it I need help with.

The sending from lotus I can get to work fine.

Anyone else able to offer any assistance?

BUMP...anyone else able to help?

Cheers Dom, that is almost what I need, I tested that for the email address and it worked, I did try to add the extra bit I need in, which is attachment.

The path of that is in column d rather than e - which is address, would you mind telling me how I can do both?

Really appreciate your help.

Cheers for your reply Dom...will give that a try once ive had my morning tea! Will let you know. Dan

Cheers Dom - That worked!