Hello,
I need some help, mabye alotHow do I go about getting an excel woorksheet 2007 to send me emails automaticlly. I have dates located in cells that an item will expire, for example, a drivers licence 10/26/2011.What I am trying to do is have an automatic e-Mail sent out to windows live mail "10 months ahead" and "1 year ahead" of the time something will expire.
Hello railside,
Welcome to the Forum!
It would help to know a few more details.
1. Will the email addresses be located on the same sheet?
2. Do you want the email sent out at both 10 months and 12 months ahead?
3. Is Windows Live your default email program or do you want to Outlook?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Leith Ross,
Thank you for the quick response,
1. Will the email addresses be located on the same sheet?
The email address can be on same sheet.
2. Do you want the email sent out at both 10 months and 12 months ahead?
Yes the email notification should be sent out at 10 months and again at 1 year.
3. Is Windows Live your default email program or do you want to Outlook?
Windows live is my default email program.
Hello railside,
What do you want the email message to be?
Leith Ross,
For the License Expires cell column, "License Expires" , for the Medical Card Expires cell column, "Medical Card Expires" ,for the start date column "Review".
Hello railside,
Hopefully one last question. Will you be logged onto to Windows Live when the workbook is open?
Leith Ross,
I was hoping that it would auto send the email notification whether I was logged on or off. But if I had to choose Logged on.I know that I typed windows live for default my bad that is my home office but this is to be used at work so the default would actually be outlook.
Hello railside,
Not a problem.
That is good to hear.
Hello railside,
I am almost finished. Should take about 10 to 15 minutes more.
Hello railside,
Here is preliminary workbook. The dates are checked for being 10 and 12 ahead. I just want to look it over before I do any more in case you want to add or change somethings. Here is the macro that has been added to the workbook. You can run it using ALT+F8
Please Login or Register to view this content.
Great will take a look at work today, I very much appreciate that you take your time to help.
Leith Ross,
It looks and works pertty good, but do I have to press alt and f8 to send email, or will it send email automatically when certain dates fall in that 10 months and 1 year range. When I send email it sends all 3 Start Date review, License Expires, Medical Card Expires even if one or two dates are well before/after 10 months or a year is close.
I would like the start date review notice to be sent at 1 year from date in B2 column
I would like the License Expires notice to be sent at 10 months from date in C2 column
I would like the Medical Card Expires notice to be sent at 10 months from date in D2 column
Thank you for time
Hello railside,
I held off on the auto mailing by date until I was sure the format was what you wanted. I will add that in. It can be setup to check the dates and send the emails once the workbook is open. Also a button could be added to manually run the macro at anytime. I should be able to that this evening.
That would be great, it is one of those files that once it is up and running don't need to see info again for awhile, just to be sent the email.
Last edited by railside; 05-07-2010 at 08:55 AM.
Leith Ross,
How are things going with the workbook, is there anything that I can do to help you help me.
Leith Ross,
Were you able to get the excelbook to work?
Last edited by railside; 05-19-2010 at 06:59 PM. Reason: fix
Is anyone able to help me with this workbook?
I'll try and look at it tomorrow if nobody else hat responded.
Ty, foxguy for anything that you can do for me.
railside;
Edited message to replace file. There was a bug in the 1st one.
Here's a file for you to test Copy of employee dates 2-2.xls. I don't have Outlook, so I had to trust that Leith's sub() worked for you.
When the file is opened it will run Send_Out_Emails(), which will send out any emails that are due, then reschedule itself to run again in 24 hours. So if you leave the file open, it will run every 24 hours. If you close the file, it will set up the schedule again the next time you open it.
The file automatically sets dates for sending out emails. You may change the dates as you see fit.
Last edited by foxguy; 05-22-2010 at 10:59 AM.
Hi, i'm working on a spreedsheet that deal with vendors Ins. . I need to send a automatic email to myself when each of my vendors policy are about to expire in 30 days. what is the best way for doing this. i am working in excel 2007 and outlook 2007.
Cheila76,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks