atuljadhavne
06-12-2012, 04:17 AM
Dear expert
I have Invoice details with due date
now what i want if due date is today than one auto mail sent to concern persone (mapped to all invoice) and cc to particular person with default subject and body text
like
Sub:- Invoice No. 12345 is due today
Body:- Dear Mr. XYZ
Invoice No. 1234 of Rs 55,000.00 is due today, please revert with expected date of payment
Regards
Credit Control
My excel having all the data
using excel 2007
I have Invoice details with due date
now what i want if due date is today than one auto mail sent to concern persone (mapped to all invoice) and cc to particular person with default subject and body text
like
Sub:- Invoice No. 12345 is due today
Body:- Dear Mr. XYZ
Invoice No. 1234 of Rs 55,000.00 is due today, please revert with expected date of payment
Regards
Credit Control
My excel having all the data
using excel 2007