can I create outlook reminders from worksheet data?
Hi, I'm looking for some advice to save some time. I have some renewal dates
for common bills in a simple excel worksheet (e.g. Car Insurance, renewal 31 July 2009) etc. I want to create reminders for these to remind me to action them. I know I can use Outlook tasks and set reminders manually, but was wondering if there was an easy way to do this automatically, so all I have to do is enter the date and what it is, and a reminder is automatcally created in Outlook. I'm running Office 2003. Or are there Macro's that can be used? (I've not really created macros so if anyone had a ready-made one that would excellent). Cheers, Graeme |
can I create outlook reminders from worksheet data?
I have some sample code here that might help:
http://www.codeforexcelandoutlook.co...rs-in-outlook/ HTH, JP On Jul 3, 10:37*am, Heywogr wrote: Hi, I'm looking for some advice to save some time. I have some renewal dates for common bills in a simple excel worksheet (e.g. Car Insurance, renewal 31 July 2009) etc. I want to create reminders for these to remind me to action them. I know I can use Outlook tasks and set reminders manually, but was wondering if there was an easy way to do this automatically, so all I have to do is enter the date and what it is, and a reminder is automatcally created in Outlook. I'm running Office 2003. Or are there Macro's that can be used? (I've not really created macros so if anyone had a ready-made one that would excellent). Cheers, Graeme |
All times are GMT +1. The time now is 10:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com