Editing a VBA code to include attachments -- 2

Job ID: 33943039

Budget: $10 – $30 USD

I have a VBA code which works fine. my requests are as follows:
1- The workbook will be in a shared drive and used by several users (not in the same time), so everything must by dynamic. Any reference to drives must be avoided (D:\ or C:\).
2- The workbook will be in a folder with some other folders. the content of those folders to be attached based on the criteria selected in the master sheet (screenshoot attached). So if I select Product1, all files inside Folder1 to be attached in the email.
3- the workbook has a Contact sheet which includes email addresses, the email generated must include them all in the BCC. and it should be dynamic as well (xlDown).
Happy to explain further if required.
Related categories: Visual Basic Excel