Email attachments using macro

[Gaura215]

I have a worksheet, which has the following:

1) Coloum A have the name of the files of the attachments;
2) Coloum B have the email addresses;
3) Coloum C have the path where the attachement are saved;

I want a macro which can email all the attachements with the name as in Coloum A to there corresponding email address as mentioned in Coloum B. All attachments are saved in the same folder, path is mentioned in Coloum C.

I want these mails to be displayed and not sent directly.

All excel/macro gurus, please help.<!-- google_ad_section_end --><!-- / message --><!-- sig -->

 

[Andrew Poulsom]

Start here:

http://www.rondebruin.nl/mail/folder2/files.htm