On 5/07/2012 7:21 PM, leslieneedshelp wrote:
Hi,

I'm new here and the forums have been quite useful. However I am getting
confused since i'm not an expert with Excel.

Currently I'm managing our referral database and I'm wondering if there
is a way to email the referring person on whether his referral passed or
failed initial screening, or is an invalid referral.

I'd appreciate very much if someone could help me out.

I'm attaching sample of how the database. Also, the excel file includes
the ff sheets: database, list used for the drop down, and the email
messages to be sent out. For the email messages, is there a way to
include the name of the referral as part of the message?

Thank you again in advance for your help :)


Leslie


+-------------------------------------------------------------------+
|Filename: ERPsample.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=453|
+-------------------------------------------------------------------+



Hi

Check out Ron DeBruin's site

http://www.rondebruin.nl/sendmail.htm

HTH
Mick.