Excel VBA Bulk emails with .oft template taken from a cell value

Hi guys,

I am working on an Excel file to send different email templates to different recipients from a list.

I'm completely newbie in VBA. I had the code bellow from a previous project but it works only for one row.

The template directory is taken from K2. The templates are different based on clients.

the client's email is taken from B2 and client number is taken from A2.

I would like to make this code work for the whole list.

Your help is very appreciated.

Thanks a lot.
Claudia

Please Login or Register  to view this content.