send email via excel for action items with overdue
I need help on the following.
I need to write a macro to send out 2 types of email via excel 2000 for those (DEPENDING ON their Action_Item_Status
1)action items with Action_Item_Status='Over Due', (over due email)
1)action items with Action_Item_Status='Due Soon', (reminder email)
My datasheet contains the following columns:-
The 'Action_Party_Email' can be duplicated.(Ie. the same email address can be found in different 'Action_Item_No' records.
In each email, i need to also include the data found in 'Action_Item_No' & "Action_Due_Date" columns.
Please kindly help.Thanks alot in advanced:)