Need help to filter attachments to certain file extensions exp. .pdf, .xls, .las

[Must06]

The Code works just need help with filtering the attachments to certain file extension for example (*.PDF, *.XLS, *.LAS) Thanks in advanced

Please Login or Register  to view this content.

[dangelor]

Possibly with...

Please Login or Register  to view this content.

[Must06]

Just tried the code you sent. it creates the email but with no attachments.

[dangelor]

The code assumes the file's name is in Range("W" & i).

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Must06]

First Click on Attachments the choose file location, it will ask you once for file location (this will put the file location on cell (W20) then once again the search for the file on that same folder. file name will be on (W22:W42). Thanks for your help

[dangelor]

Try this version...

Please Login or Register  to view this content.

[Must06]

Same results as before it creates the email but no attachments. Thank you for being patient and for your help.

[dangelor]

Try this...

Please Login or Register  to view this content.

[Must06]

Thank you for all your help that did the trick.

[dangelor]

Glad to do it!