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.
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.