Editing a VBA code to include attachments -- 2
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.
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.