$$Excel-Macros$$ Macro to send emails using excel list

2010-05-14 Thread Fabio Sascho
Dear friends Below you can find the code I wrote to make Excel send emails thought a list of names My problem is the attachment talk. I need a code that gets all files from a certain directory and attach into the email using the " .attachment.Add" Does anyone know how to do that ?

$$Excel-Macros$$ VBA Macro that send emails with 5 attached files from one directory

2010-05-10 Thread Fabio Sascho
Hello there I already have prepared the macro that gets the mail Addresses and names and prepares the email to me, however I don´t know how to attach all files from a certain directory. The method would be “With myItem .attachement.add “file to be attached” End wi