Hi,
I have a workbook showing the jobs which consultants are being paid for in the latest payment run. This consists of a front sheet and then a sheet for each consultant.
I'd like to run a macro which emails the relevant sheet as an attachment to the relevant recipient.
I would imagine it would be best to have the relevant email address picked up from the same cell on each of the respective sheets, in this case A12. The front sheet does not need to be sent.
I'm using Excel 2007 and Outlook 2007.
I've played around with some VBA and managed to achieve part of this and will keep reading up but any help is appreciated.
Thank you.
I have a workbook showing the jobs which consultants are being paid for in the latest payment run. This consists of a front sheet and then a sheet for each consultant.
I'd like to run a macro which emails the relevant sheet as an attachment to the relevant recipient.
I would imagine it would be best to have the relevant email address picked up from the same cell on each of the respective sheets, in this case A12. The front sheet does not need to be sent.
I'm using Excel 2007 and Outlook 2007.
I've played around with some VBA and managed to achieve part of this and will keep reading up but any help is appreciated.
Thank you.
