Hi
Apologies if this has already been asked, but I am new to VBA and am keen to utilize it in my job to make life easier!
In my Excel spreadsheet I have a list of approx. 30 projects in cells within column C, against each project, in columns D, E, F and G are as follows:
D: Total Number of units
E: Units Complete
F: Units incomplete
G: % Complete
I have to send an E-mail each month to 4 colleagues who require an update on the projects.
What I would like to do, is have Excel generate an automatic, reoccurring E-mail on the 5th of each month, which copies the contents of the cells in the body of the E-mail to the 4 colleagues, ideally without me having to go into Excel at all. All of the information which I want to send it within cells C1:G26. I don't want to attach the document itself, only the relevant information from Sheet 1.
I would like this sending on 5th of each month at 11:00 via Outlook. Can anybody help? is this even possible? if not, is there a close alternative?
If it is possible, are there any constraints? e.g. I have to have the excel document open, or I have to be logged into Outlook and active? if I wasn't logged in would the E-mail send automatically or would it 'roll over' to the following month?
Hope this makes sense, thanks in advance!
Jack
Apologies if this has already been asked, but I am new to VBA and am keen to utilize it in my job to make life easier!
In my Excel spreadsheet I have a list of approx. 30 projects in cells within column C, against each project, in columns D, E, F and G are as follows:
D: Total Number of units
E: Units Complete
F: Units incomplete
G: % Complete
I have to send an E-mail each month to 4 colleagues who require an update on the projects.
What I would like to do, is have Excel generate an automatic, reoccurring E-mail on the 5th of each month, which copies the contents of the cells in the body of the E-mail to the 4 colleagues, ideally without me having to go into Excel at all. All of the information which I want to send it within cells C1:G26. I don't want to attach the document itself, only the relevant information from Sheet 1.
I would like this sending on 5th of each month at 11:00 via Outlook. Can anybody help? is this even possible? if not, is there a close alternative?
If it is possible, are there any constraints? e.g. I have to have the excel document open, or I have to be logged into Outlook and active? if I wasn't logged in would the E-mail send automatically or would it 'roll over' to the following month?
Hope this makes sense, thanks in advance!
Jack