Hi friends,
There are several contacts in my directory and daily only 1-2 birthdays or sometimes not a single birthday. The anniversary macro searchhhes for a person whose birthday is on that particular date and send automatic email to him. For it the macro has to run till last entry in my directory that means about 1000 or more entries. It takes a lot of time to send 1-2 mails. I want to sort out the date after opening the file first and bring the current date on top and the anniversary macro should run only for that current date and then stop. For it I inserted a sortdata macro but it sorts the dates in ascending order and not bring the current dates on top.
Requirements:
After opening the file the sortdata macro should run first and bring the current dates on top.
Then the anniversary macro should run only for that current dates and stop
This will save my time and speed up the task.
Please help me to solve this problem.
Thanking you in anticipation.
Mukesh
Bookmarks