• Create a table to add the file names into it e.g.

    CREATE TABLE EmailTask(Name VARCHAR(20))

    INSERT INTO EmailTask(Name)

    SELECT 'ABCD'

    UNION

    SELECT 'HERH'

    ...etc

    Create a 'object' variable called 'objName' then a string variable called 'strName'.

    Use 'Execute SQL Task', and in the editor on the main tab write a sql statement to extract these names. e.g SELECT DISTINCT [Name] FROM EmailTask. Set 'ResultSet' to 'Full result set'. Go to the result set tab and add in 'objName'.

    Now add a foreach loop container. In the editor, on the collection tab, set the enumerator type to 'Foreach ADO' and select 'objName', and under 'Enumeration mode' tick 'Rows in first table'.

    Go to the variable mappings tab and add 'strName'.

    Then just pop a send mail task inside the loop container and configure it. In the editor, go to expressions. Add a property for 'To' and 'Attachments' and build an expression for both. E.g 'To' might be @[User::Name] + "@gmail.com", and 'Attachments' might be "C:\\EmailAttachments\\" + @[User::Name]