How do i set up monthly reminders using contact info?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VerynewtocompUSMC - 24 May 2006 04:29 GMT

2003 Office Basic
Using my calendar and contacts, I would like to set up a monthly event for
all my contacts using the day of their birthday to indicate the day of the
event. Example my birthday is on the 30th of the month. I would like outlook
to have my name show every month on the 30th as a reacurring event. I need to
do it for 6000 contacts. I understand i can do it individually but it will
take me 6 months to do with my schedule. Can I actually do this?

Small Buisness owner

Reply to this Message

Diane Poremsky [MVP] - 24 May 2006 05:09 GMT

Outlook doesn't support anything like that natively... but you can make the
job easier using Excel.

I would set one event up using the criteria and export to excel - this is so
you can see the fields you need and the data value needed. Next I would
create a view in contacts with the fields I need (Name and b-day) and copy
and paste them into Excel - then use Excel's features (formulas or VBA) to
convert each b-day to a recurring date then paste them into the sheet with
the fields I exported first. Use fill to fill in the values for the fields
that don't change.

Signature

Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

> 2003 Office Basic
> Using my calendar and contacts, I would like to set up a monthly event
[quoted text clipped - 9 lines]
>
> Small Buisness owner

Reply to this Message

Rate this thread: