Tech Support Guy banner
Status
Not open for further replies.

Excel - Trigger Auto Email Depending on Due Date

1K views 1 reply 2 participants last post by  draceplace 
#1 ·
Hello Everyone,

I am a beginner at using vba and I am trying to use excel to send an email automatically before 5 days of due date. I have a an excel sheet of bank loan repayment but every loan due at a different date.

If possible i would like to use an email template that excel would place the values specific payment details and their due date and then send the email to the email address on the specific cell.

I have attached my excel sheet format for your referance.


Thank you so much in advanced

Regards,
Nilesh Jagtap
 

Attachments

#2 ·
Welcome to TSG niljag!

Working on one of these right now at this TSG thread . Practice1.xls in Post #4 is lastest. See if you can adapt to similar. I didn't look at your attachment.

There are many of these(excel emailers) in TSG. Search "excel email" and find one you like. When you get to an issue let us know and we'll try and help.
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top