E-mail Notifications

Hello all,

I have a spreadsheet that has a list of products that I need to order and dates that they need to be ordered by. I would like to set up e-mail notifications when the date required to order is 10 days away. From my research it looks like I need to write some code to accomplish this. I haven't done anything with VB for about 8 years, could someone help me out?

Thanks, I really appreciate it.

-KB

Please confirm which e-mail you are using (Lotus, Outlook or any web based)?
How you want to send the mailer i.e clicking on a button or any event based?

If You are satisfied with my solution click the small star icon on the left to say thanks.

Outlook and I'd like it event based on the current date.

In order for it to be time-based, the workbook would always need to be open, and a function/procedure would always need to be running to check the time. This is very inefficient, in my mind. The solution to this would be, when a record is created or updated, to create an Outlook appointment for that date/time. Outlook has been designed to generate notices based on time and so is the preferable tool.

If you provide a sample workbook that describe the type of data you will be recording, and the flow of the work, this would be very helpful in designing a solution that suits your needs.

I agree that that's inefficient and would definitely be open to the Outlook appointment route.

I've attached a sample of the workbook I'm using. I would want it based off of the "Hypothetical Order Date" column. I've put conditional formatting on that column but would like a more direct notification when the date is getting closer.

Again thanks for the help, this is definitely over my head!

Try this:

Please Login or Register  to view this content.

The above code assumes that you are changing only a single cell at a time.

KB,
I would reccomend visiting Ron De Bruins website which has a number of examples on sending emails from Excel, his website is here

Iain