Setting a Reminder in Outlook via Excel

**yka** · 08-21-2008, 08:06 AM

I've tried numerous things I've found here in the forums with no success.

Essentially, I am trying to populate a calendar entry, with reminder, in Outlook using data from Excel.

For instance, if Cell A1 is a date, I would like to automatically make a calendar entry for that date that would bring up a reminder in Outlook.

I hope that makes sense.

I'm open to other ideas as well if you think there's a better way to remind a user of an impending, or past, date; such as expiration of an order.

**yka** · 08-21-2008, 01:39 PM

I almost had it...I thought. I was going to create a task instead of a calendar item. I found this code online:

Please Login or Register  to view this content.

It runs through everything...but no task is created. I'm very confused.

**yka** · 08-21-2008, 02:46 PM

Ok, got it, finally!

Please Login or Register  to view this content.

Now, the only problem, and I REALLY hope someone can help:

I want the .Start to generate based on the data in a cell. ?? Help!

**dumbguy** · 07-17-2018, 05:19 PM

can anyone help me do the same type of thing? I can send a sample of my excel file. Basically, I am setting up a date in excel. I would like to set up a alert/reminder in outlook 60 days prior to the date in excel. Can this be done?

**FDibbins** · 07-17-2018, 11:07 PM

dumbguy welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**dumbguy** · 07-18-2018, 01:01 PM

My apologies. I do not see an option to start a new thread. Also, was not aware I was breaking the rules. Very sorry.

**AliGW** · 07-18-2018, 01:05 PM

Go to the forum section where you wish to post (e.g. the VBA section) - there's a big, blue button top left that says + Post New Thread - click on it and away you go!

https://www.excelforum.com/excel-pro...ng-vba-macros/