How do i set up monthly reminders using contact info?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top