Dear All,
I wish to create an Excel worksheet to send email reminders to people based on deadlines I specify. Please help.
Dear All,
I wish to create an Excel worksheet to send email reminders to people based on deadlines I specify. Please help.
What email client do you use?
If you use Outlook you may find it more effective to use either Flags on emails, or Tasks, rather than using Excel to do this.
However, if you want to use Excel, you should draft an Excel file for how you want this data to look, and we can then help with the macro to send the email at the appropriate time. You will need to think about:
Do you want the reminders to be sent based on an automatic timer, or when you press a button to initiate it?
If automatic, when do you want to evaluate the deadline to determine if a reminder is due to be sent? Daily? Hourly? Remember that this can only happen if the Excel file is open.
You will need a way to note that the reminder has been sent, such as a column indicating when it was sent, to prevent duplicates.
To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
Dear Jeff,
Greetings of the day
I want to draft a project cycle in Excel as below:
Work Description Responsibility Due Date Email EMAIL BODY Reminder 1 Reminder Sent Date
Thank you.
Khadija.
Hi Jeff,
Please refer the attached excel template.
I plan to get it done as mentioned in the template.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks