p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Excel VBA (http://p2p.wrox.com/forumdisplay.php?f=79)
-   -   send email via excel for action items with overdue (http://p2p.wrox.com/showthread.php?t=57938)

miracles May 16th, 2007 02:20 AM

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







All times are GMT -4. The time now is 08:49 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.