Email notification of expiry date

**pavan_sv** · 04-04-2014, 01:26 AM

Hello

I am looking for help on solving this, I am looking for a way to be able to send an email notification 30 days before the expiry date of passport.
Is there anyway of doing this using a macro or through VBA? column A contains Name, column B contains expiry date and column C contains email address.

Could you also suggest on following:
1. Can this code be made to work - without starting the outlook in background? - as I see this code should work without starting the outlook - but it doesn't
seem to work for me.
2. If I wish to use my SMTP mail server , is there any provision in the VBA to code for SMTP send mail - like we do in code?
3. If I wish to consolidate some data - based on that expiry date criteria and then put into an Excel sheet and then mail the sheet itself as a report - would it be
possible? I guess - Yes but I don't know how to do it.

thank you..!

**TMartin79** · 04-11-2014, 10:29 AM

If there is a solution to this, I would like to know. I have not yet found a way to generate and send an email without Outlook, but there MUST be a way....somewhere....somehow.

**osamarizwan** · 04-22-2022, 01:00 AM

Hello,

I am trying to figure it out that what code can be applied in excel file that help me to send expiry notification via outlook email for the contract with 30 days left.
attached is the specimen sheet. also note i want a code that can work even the system of excel file is not opened.

thanks
osama