Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

How to make Excel send email alerts to Outlook


(!)

SSGTGARCIA's Avatar
SSGTGARCIA SSGTGARCIA is offline
Computer Specs
Junior Member with 3 posts.
THREAD STARTER
 
Join Date: May 2007
Experience: Beginner
15-May-2007, 02:02 PM #1
Cool How to make Excel send email alerts to Outlook
I created an excel workbook and would like to have excel automatically send me a reminder to my Outlook email when certain due dates are coming up.

Is this possible? I tried playing around with Macros but I'm not good at it. Any assistance is greatly appreciated.

respectfully,
Edward
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,545 posts.
 
Join Date: Mar 2005
Location: UK
15-May-2007, 05:53 PM #2
Edward, this will only work while the Excel Workbook is open.
But it can be done, in fact there may well already be a post on here.
Rollin_Again's Avatar
Member with 4,693 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Advanced
15-May-2007, 07:23 PM #3
As OBP already stated, you can do this quite easily with a VBA macro but you will need some type of event to trigger the macro. Do you want the macro to run when each time the workbook is opened? Do you want it to run each time a change is made to one of the cells? Please provided more details and post a sample workbook if possible so we can see what you are talking about. If the workbook simply needs to remain open and the code run at intervals we may need to include some type of timer control or OnTime event to fire the code at your designated times.

Regards,
Rollin
SSGTGARCIA's Avatar
SSGTGARCIA SSGTGARCIA is offline
Computer Specs
Junior Member with 3 posts.
THREAD STARTER
 
Join Date: May 2007
Experience: Beginner
16-May-2007, 01:48 PM #4
How to make Excel send email alerts to Outlook
Rollin,
I've attached a copy of the Workbook, I had to remove a few worksheet to meet 200kb. The workbook is basically a tracking system for when Performance reports are due for my Marines. For example the worksheet named "FITREP TRIGGERS" has the month that Fitness Report (FITREP) is due for Sergeants (Sgt) ie Mar for Active Duty and SEP for reserve components. I would like excel to send an email on the 1st of the Month of Mar and Sep to remind me that Sgts FITREPS are due within 30 days. Hope this clarifies what I'm trying to do.

Thanks

Edward
Attached Files
File Type: xls Blank RS profile.xls (179.5 KB, 4057 views)
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,545 posts.
 
Join Date: Mar 2005
Location: UK
17-May-2007, 12:20 PM #5
Edward, here is a coincidence, see this post -

http://forums.techguy.org/business-a...ata-excel.html
SSGTGARCIA's Avatar
SSGTGARCIA SSGTGARCIA is offline
Computer Specs
Junior Member with 3 posts.
THREAD STARTER
 
Join Date: May 2007
Experience: Beginner
21-May-2007, 10:17 AM #6
OBP,
Thanks for the link. That file is sort of what I was looking for. Is there a way to have excel automatically send the email? for example can I create a field to show the current date in excel and have a field that show the date due. Say if I open the workbook and today's date is May 1st and I have more than 1 field that have a due date of May 1st. I want excel to send an email to multiple user whenever the field with the due date is equal to the current date. Hope I make sense..
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑