HI, Its my first post here. I need to send reminder mails from outlook based on excel reminder dates.
For this i should not open excel neither i know VBA scritping for this.
Please provide help on this.
As i attached my file i need list of assets need to be calibrated ahead of 45 days of calibration due date.
Hi, welcome to the forum.
There are may posts with similar requests as well as automatic execution of similar scripts, have you at least searched for these?
Excel has to be opened (even if it's in the background) and trigger mechanisms have to be present.
I've helped with quite a few of these. I'll take a look if I can do anything for you, but I seriously suggest you do a search for all the options to automatically send a message based upon due dates. The automatic part I can help you with.
May I point out that your file contains private data like email and phone numbers as well as names and so.
Please ask a moderator to delete this file and you should replace the data with dummy data since it's only about the VBA code.
I've attached a clean file with non-private data and the idea, not worked out yet.
Oh yes, one thing, please do not use merged cells, it's terrible and a nightmare for programmers.
I removed them and you can see for yourself that the result is the same bu at least you can work with the file now.
I've removed the attachement you posted as it contained email addresses, phone numbers etc. If you want to upload a new one (or use the one that Hans attached), that would be great
Thanks Eddie, hope the poster appreciates it @anusha.ankam You have to give us more information like what does the email message have to say:
Subject, message, etc. etc.
Thanks alot.
Actually i have related posts but could not get any proper solution may be as i dont have proper knowledge on excel .
Subject : Calibration due dates
Email message : Calibration for below items is 45 days away. Please Check Equipment Calibration Excel for further details,
XXX (From Excel)
XXX (From Excel)
XXX(From Excel)
Okay, I worked something out.
The attached file contains a module named CheckandSendMailModule
The macro to trigger it is named CheckAndSendMail
If you Open Excel it will not send anything and you will have to trigger it manually
The Macro named MailData requires parameters and takes care of sending the mail.
You will have to edit this macro to actually send a message:
Code:
.Save ' This property is used when you want to saves mail to the Concept folder
.Display ' This property is used when you want to display before sending
' .Send ' This property is used if you want to send without verification
You must place an ' in front of Save and Display and remove it where it says Send
The result is as follows:
A mail message with the subject: Calibration due dates
And the message body
Calibration for below items is 45 days away. Please Check Equipment Calibration Excel for further details:
COG-SCADA-002
COG-SCADA-004
COG-SCADA-005
COG-SCADA-013
The zip file also contains a vbs script, this file must be kept IN THE SAME folder as qhere you keep the Excel file and this file can be invoked daily using a scheduler to open the file and run the macro automatically
The contents of the zip file:
- EquipmentCalibradtion(SCADA).xlsm
- CheckAndSendMail.vbs
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!