View Single Post
  #1 (permalink)  
Old May 16th, 2007, 02:20 AM
miracles miracles is offline
Authorized User
 
Join Date: Mar 2007
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default send email via excel for action items with overdue

Hi,
     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:-
Action_Item_No
Action_Party_Email
Action_Item_Status
Action_Due_Date

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





Reply With Quote