Attach 2 or more email files

[stokak]

I have successfully created the vba code to attach a file and send an email. However, when I try to attach a secon file using a second .Attachments.Add sFileName , it simply replaces the one attachement with the second one and only has one attachment. I have seen places where comments were only one could be attched, and I have seen code examples showing looping thru to add more attachement files...Can it be done ?
Stoka.

 

[Craig Ottley]

You can definatly do this in a loop...

check out Ron De Bruins site here

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