Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-31-2016, 12:36 PM
cassie4258 cassie4258 is offline Help with generating auto email and calendar macro Windows 7 32bit Help with generating auto email and calendar macro Office 2013
Novice
Help with generating auto email and calendar macro
 
Join Date: May 2016
Posts: 2
cassie4258 is on a distinguished road
Default Help with generating auto email and calendar macro

I need to do several things with this spreadsheet, and I'm not nearly familiar enough with the coding part to figure it out. Help will be much appreciated... especially with the email portion.

1.) I made a calendar macro (smiley face at top of spreadsheet) to fill in the "date" cells, but I would like it to pop up automatically when someone clicks in one of those boxes.

2.) I need the "number of days past due" to automatically calculate as a running talley when set to "past due" status

3.) The "tip" note doesn't pop up for every date blank like the "employee" one does, just the first cell at the top of column does.

4.) For the email portion, I would like Excel to send an email to the selected employees reminding them when the "status" flips to "past due"... and then at a regular interval afterwards, say once a week. Also wondering if there is a way to copy a supervisor on every past due reminder that is sent.



Thank you all in advance!
Attached Files
File Type: xlsm CorrectiveActionsSample.xlsm (30.3 KB, 13 views)
Reply With Quote
 

Tags
calendar, email, macro



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with generating automatic email when "status" changes to past due cassie4258 Excel 1 06-04-2016 09:00 AM
Help with generating auto email and calendar macro Macro to change font in email, dependent on which email account is being used gb82 Outlook 2 01-23-2016 01:54 AM
Help with generating auto email and calendar macro Auto-populate key fields in an email? ryebanana Outlook 1 07-21-2015 04:25 AM
Lack of email addresses auto-populating LarryK Outlook 0 10-10-2012 08:09 AM
Auto entry of email address (who I'm sending to) Miket Outlook 5 12-10-2008 04:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft