How do i set up monthly reminders using contact info?
 

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

How do i set up monthly reminders using contact info?
 

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.

--
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:



"VerynewtocompUSMC" wrote in
message ...
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