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

[brezgesla]

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!

[AlphaFrog]

Add them as attachments in a loop like you did when you printed them to the immediate window.

Please Login or Register  to view this content.

[AlphaFrog]

On another note; the .Find method "remembers" the last settings used for each argument. In the code below, you specify the search direction in the second instance of the .Find command, but not in the first. That means in the next loop, the first instance will also use the xlPrevious direction. I don't think you want that. I suggest to explicitly set all the relevant arguments for the Find command in each instance just to be safe.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[brezgesla]

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

[AlphaFrog]

Do you put the code in the right place?

Please Login or Register  to view this content.