Automating Task within Excel To Send Emails

  • Thread starter Thread starter JamesW
  • Start date Start date
J

JamesW

We have a user who currently uses a simple spreadsheet to list certain types
of enquiries they get. They would like to set up a macro, or such, to enable
an automatic prompt, for example an email, to be sent to a member of staff if
something hasn’t been done by a certain time to remind them they need to do
something. The speadsheet deals with multiple enquires assigned to multiple
users.
 
Thanks Mike,

However what we need to do is for the task\macro to look at a cell, with a
date in it, and then compare it to the current date and if it is older then
current date email the user. This information is all on one sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automating use of complicated formula 4
Creating a task in Outlook from a date in Excel 4
Access Automatically Send a notification email once a record is added 0
Locking Cells in an Automated SpreadSheet 1
Include a value from one cell within text of another cell. 2
send reminder email through outlook based on info from a csv/excel file 0
Copy last data entered into mulitiple sheets within a workbook? 2
Error in email attachments within emails 3

Back
Top