PDA

View Full Version : Auto Email



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

dazwm
06-12-2012, 06:15 AM
This may help.

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

CodeNinja
06-12-2012, 06:28 AM
atuljadhavne,
You certainly can do this through excel, however, outlook may be an easier choice. Simply set a recurring trigger to check excel (ado or however you want) for past due invoices then send off desired form.
If you do this in excel, you may have some difficulty getting the automation to trigger on a daily basis...

Good luck.

Tinbendr
06-12-2012, 06:40 AM
Here's my effort.

atuljadhavne
06-16-2012, 02:06 AM
its working fine thx expert