Dear Forum members,


I need your help to create an excel macro. My goal is to create an excel file that handles thousands of documentations. The program should do the following:

-Automatically open a userform (done)
-Asking me for the ID codes (I will have to enter multiple lines)
-When I'm done with it It should lookup for the search ID and copy the linked files into an outlook mail attachment. The files are: .doc,. pdf

-In case I search something that it not exist yet write it into the mail body section that it's missing wit the ID codes
-In case the attachment is over the limited size It should send it in two parts.
Last one doesn't seems easy, so I would be happy If it just collecting data into a specific folder in my computer.


Thanks in advance