Hello all! I am curious if a task is possible with VBA. I work with a huge spreadsheet that I would like to automate. The data under each client will need to be copied and saved to a new worksheet and then we email out individual worksheets using a template. There is an Outlook contact named with the client #. Would it be possible to save each and search outlook for the contact to email the spreadsheet to?
In the spreadsheet example, I would need to end up with 4 spreadsheets. One for each client # listed and then email it to that contact.
I hope I am explaining this clearly.
I don't mind putting the work in to get this going, just not sure if it is even doable.
Thanks in advance!!!
In the spreadsheet example, I would need to end up with 4 spreadsheets. One for each client # listed and then email it to that contact.
I hope I am explaining this clearly.
I don't mind putting the work in to get this going, just not sure if it is even doable.
Thanks in advance!!!