MixedUpExcel
Board Regular
- Joined
- Apr 7, 2015
- Messages
- 222
- Office Version
- 365
- Platform
- Windows
Hi,
I've not been on here for a while but I'm hoping someone might have some suggestions / point me in the right direction.
Outline:
I have a spreadsheet with 4 columns of dates, next to each date is an email address, next to each email address is a cc email address, next to each cc email address is a subject, next to each subject is a message
eg. - Just using the first 2 parts of 4
I would like to be able to do the following:
Without opening the Workbook, when one of the dates in the 4 columns matches today's date, it triggers an email to be sent.
The email is to be sent to the email address next to the date that today has just matched.
The email is to also be sent to the cc email address.
The email is to have the subject and content that is next to the date that has just been matched.
The data set I have is much bigger but the above are the key triggers and actions.
From some research, I know the following:
I have to put the vba code within the worksheet (rather than a module) and use Worksheet_Change
I need to use a loop to go through each of the columns to check the dates, so that when one of them or possibly more match today's date, it triggers an e-mail alert
Finally, if all of the above is possible, I would like to save this workbook to a company SharePoint (not compulsary)
Any help would be gratefully accepted.
Thank you in advance.
Simon
I've not been on here for a while but I'm hoping someone might have some suggestions / point me in the right direction.
Outline:
I have a spreadsheet with 4 columns of dates, next to each date is an email address, next to each email address is a cc email address, next to each cc email address is a subject, next to each subject is a message
eg. - Just using the first 2 parts of 4
23/12/2022 | simon@abc.com | simon1@abc.com | Bakers Lot | Bakers Dozen | 03/01/2023 | james@abc.com | james1@abc.com | Crumpets | 2 Dozen |
I would like to be able to do the following:
Without opening the Workbook, when one of the dates in the 4 columns matches today's date, it triggers an email to be sent.
The email is to be sent to the email address next to the date that today has just matched.
The email is to also be sent to the cc email address.
The email is to have the subject and content that is next to the date that has just been matched.
The data set I have is much bigger but the above are the key triggers and actions.
From some research, I know the following:
I have to put the vba code within the worksheet (rather than a module) and use Worksheet_Change
I need to use a loop to go through each of the columns to check the dates, so that when one of them or possibly more match today's date, it triggers an e-mail alert
Finally, if all of the above is possible, I would like to save this workbook to a company SharePoint (not compulsary)
Any help would be gratefully accepted.
Thank you in advance.
Simon