accountant124
New Member
- Joined
- Sep 26, 2019
- Messages
- 4
Maybe a bit of a long shot but I thought I'd give it a go anyway!
I have a set of data, from which there are a number of (formula driven) extracts in other sheets within the same workbook. I'm looking for a macro which will go down the contacts list, see which extracts each contact needs and send the relevant one to them in a separate email with an attachment.
A couple of issues:
1) The extract will need to be hard coded/valued before it is saved/sent.
2) The extracts/attachments which are sent need to be saved in an archive folder location.
I've attached a set of data which replicates the data I have.
Thanks in advance for your help!!
I have a set of data, from which there are a number of (formula driven) extracts in other sheets within the same workbook. I'm looking for a macro which will go down the contacts list, see which extracts each contact needs and send the relevant one to them in a separate email with an attachment.
A couple of issues:
1) The extract will need to be hard coded/valued before it is saved/sent.
2) The extracts/attachments which are sent need to be saved in an archive folder location.
I've attached a set of data which replicates the data I have.
Thanks in advance for your help!!