How to set reminders from Excel data

**aip_58** · 02-13-2012, 09:23 PM

Hi,

I need help to set a reminder in outlook to remind me of the billing schedule. However, I have long list of it and it is in excel. I would like to know if there's a way to set a remnder in outlook while getting its data in Excel. Let's say for Example: In column A- the date that i need to issue the Invoice, in column B- the name of the customer that needs to be invoice. In the reminder, I want to appear in the reminder : Please invoice customer ###(referring to column B).

Hope you can help me.

Thanks

**Domenic** · 02-15-2012, 05:26 PM

Assuming that the data starts at Row 2 in Column A, try...

Please Login or Register  to view this content.

Note that the reminder is set for 9:00 AM on the due date. Change this and other properties, accordingly.

**aip_58** · 02-16-2012, 06:17 PM

Thank you very much. The code is working. You are such a great help..thank you ..

**Domenic** · 02-16-2012, 06:43 PM

You're very welcome! Thanks for the feedback!

**bobvjsingh** · 06-07-2013, 01:40 AM

Hi I am new to this, but seems like very interesting, please let me how could I work an example or please send me a sample excel file. Thanks, Bob

**reyrey** · 10-15-2013, 08:53 PM

great job!!!!

**chinwe** · 01-21-2014, 11:57 AM

please i need similar macro to set reminders from excel data. i have registered with the site but still cant access it

**arlu1201** · 01-21-2014, 12:38 PM

Chinwe,

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.