Loop through folders and send email via excel

[arvarr]

Hi
Can someone please kindly offer some assistance?

Example:
I have 10 files in a directory.

File A
File B
File C
File D
File E and so on......

Is there a way of selecting say File A, File B and File C from the folder without opening the files and then sending it via excel vba.

I have used the following code but it is only when the active workbook is open.
ActiveWorkbook.SendMail Recipients:="abc@abc.com"

Thanks.

 

[PHV]

You may use CDO:
thread705-1369407

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[arvarr]

Hi PHV
Thanks for the info. Works like a gem.