Split files and attach them to an email

[Kartyk]

Hi All,

I am working on a code to split files based on an ID and then attach each of those files into an email.
I have done most of the stuff but am stuck with one final thing.


Steps go like this :


* I create new temporary sheets within a workbook and split the files.
* i have coded in such a way that the path and file name gets copied to a column within the tem file
* however, am stuck where I need this path to be copied to main file where it matches the broker code
* this way, my other code will pick this path and attach the file accordingly.

If you refer to the attachment,


Sheet3 is temporary sheet and Contacts is primary sheet.

Match Column A from "Contacts" sheet to Column B of "Sheet3" and then populate Column E under "Contacts" sheet.



Any help would be much apreciated

Cheers
K