Excel Mailing List to Email WorkBooks, via Mailing list in lotus notes:

[N1ck9141]

Hi I am wondering if someone can help...

Here is the situations i have Excel work books in folder "C:\Files"

I have a mailing list in excel that contains

<A> <B>
"Adam@Adam.com" Gets file "Eve"
"Jesus@Jesus.com" gets files "God"

And this needs to be sent via mail client Lotus Notes

So i need a code that will produce an emails going down the list, using email address from column <A> and attach the appropriate file from column <B> ....
All files are saved in the same folder C:\File (example)

can anyone help? Thank you in advance.

 

[N1ck9141]

re posted as this one formatted incorrectly.