Setting a dynamic file list in array to be added as mail attachments

Hi

I have just scratched the surface of arrays in Excel and got stuck at setting up the dynamically occuring file links, which should be added to Outlook e-mail as attachments.

I am at first checking many hundreds of rows of data. In a certain row all cells are already sorted from A-Z, so there may be several equal values - some occuring only once, other two times or more. Every different value is defined as fixed range in first level loop. In second level loop I am trying to set up a dynamic list of local file links, to be used as attachments in Outlook mail by using an array. Current code gives me result, as can be seen in an immediate window:
D:\TEMP\File1.pdf
D:\TEMP\File2.pdf
D:\TEMP\File3.pdf
D:\TEMP\File4.pdf

So links are succesfully added dynamically to the array list, but I cannot figure it out how to use these for file attachmenst in an Outlook email. Any help greatly appreciated!

My current code:

Please Login or Register  to view this content.

THANK YOU!

Hi

For the part ".Attachments" I get an error "Compile error: Invalid or unqualified reference"

Please Login or Register  to view this content.

I would kindly ask you for another run, thank you